Sell it | Search it | Buy it

Browse through some of our most popular categories and more..

Top picks for you

jobs

Sign In

Application Log
Timestamp Level Category Message
13:25:22.663153 info application
User: Guest (ID: )

$_SERVER=array (
  'CONTEXT_DOCUMENT_ROOT' => '/home2/yasfinde/public_html',
  'CONTEXT_PREFIX' => '',
  'DOCUMENT_ROOT' => '/home2/yasfinde/public_html',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'H2PUSH' => 'off',
  'H2_PUSH' => 'off',
  'H2_PUSHED' => '',
  'H2_PUSHED_ON' => '',
  'H2_STREAM_ID' => '1',
  'H2_STREAM_TAG' => '147-1',
  'HTTP2' => 'on',
  'HTTPS' => 'on',
  'HTTP_ACCEPT' =>
'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_ACCEPT_ENCODING' => 'gzip',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_CDN_LOOP' => 'cloudflare',
  'HTTP_CF_CONNECTING_IP' => '54.80.173.217',
  'HTTP_CF_IPCOUNTRY' => 'US',
  'HTTP_CF_RAY' => '6b8d999e8a6d6fb9-IAD',
  'HTTP_CF_VISITOR' => '{"scheme":"https"}',
  'HTTP_HOST' => 'www.yasfinder.com',
  'HTTP_IF_MODIFIED_SINCE' => 'Tue, 26 Oct 2021 23:49:39 GMT',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'HTTP_X_FORWARDED_PROTO' => 'https',
  'HTTP_X_HTTPS' => '1',
  'PATH' => '/bin:/usr/bin',
  'PHP_INI_SCAN_DIR' =>
'/opt/cpanel/ea-php72/root/etc:/opt/cpanel/ea-php72/root/etc/php.d:.',
  'QUERY_STRING' => '',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '54.80.173.217',
  'REMOTE_PORT' => '29946',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_SCHEME' => 'https',
  'REQUEST_URI' => '/',
  'SCRIPT_FILENAME' => '/home2/yasfinde/public_html/index.php',
  'SCRIPT_NAME' => '/index.php',
  'SCRIPT_URI' => 'https://www.yasfinder.com/',
  'SCRIPT_URL' => '/',
  'SERVER_ADDR' => '162.241.226.46',
  'SERVER_ADMIN' => '[email protected]',
  'SERVER_NAME' => 'www.yasfinder.com',
  'SERVER_PORT' => '443',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'SSL_TLS_SNI' => 'www.yasfinder.com',
  'UNIQUE_ID' => 'Yay9wl8P7R0ajU_Dwe8yBAAAkww',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => '1638710722.6607',
  'REQUEST_TIME' => '1638710722',
  'argv' => 
  array (
  ),
  'argc' => '0',
)
13:25:22.677052 trace system.CModule
Loading "log" application component
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.679325 trace system.CModule
Loading "systemInit" application component
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.679979 trace system.CModule
Loading "frontendSystemInit" application component
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.680366 trace system.CModule
Loading "urlManager" application component
in
/home2/yasfinde/public_html/apps/frontend/components/init/FrontendSystemInit.php
(25)
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.681756 trace system.CModule
Loading "cache" application component
in
/home2/yasfinde/public_html/apps/frontend/components/init/FrontendSystemInit.php
(25)
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.684603 trace system.CModule
Loading "request" application component
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.688302 trace system.CModule
Loading "options" application component
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(41)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.688790 trace system.CModule
Loading "hooks" application component
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(45)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.689502 trace system.CModule
Loading "db" application component
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(161)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(48)
13:25:22.690706 trace system.db.CDbConnection
Opening DB connection
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(161)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(48)
13:25:22.694542 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.common'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(48)
13:25:22.694550 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')
13:25:22.695142 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')
13:25:22.695525 trace system.CModule
Loading "ioFilter" application component
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(55)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.699165 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.urls'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(103)
13:25:22.699171 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')
13:25:22.699424 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')
13:25:22.699596 trace system.CModule
Loading "extensionsManager" application component
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(75)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.709397 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
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.709405 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')
13:25:22.709703 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')
13:25:22.709805 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.translate.data'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/init/ExtensionInit.php
(108)
13:25:22.709811 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.data')
13:25:22.709991 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.data')
13:25:22.710032 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-ipinfoio'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.710037 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-ipinfoio')
13:25:22.710203 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-ipinfoio')
13:25:22.710242 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
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.710247 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')
13:25:22.710431 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')
13:25:22.710529 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.data'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/init/ExtensionInit.php
(108)
13:25:22.710534 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.data')
13:25:22.710741 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.data')
13:25:22.711100 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-telize'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.711106 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-telize')
13:25:22.711370 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-telize')
13:25:22.711417 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
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.711422 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')
13:25:22.711590 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')
13:25:22.711630 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
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.711635 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')
13:25:22.711818 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')
13:25:22.711859 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
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.711864 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')
13:25:22.712039 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')
13:25:22.712080 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-locatorhq'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.712084 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-locatorhq')
13:25:22.712243 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-locatorhq')
13:25:22.712282 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
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.712287 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')
13:25:22.712434 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')
13:25:22.712471 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
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.712475 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')
13:25:22.712630 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')
13:25:22.712688 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-freegeoip'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.712693 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-freegeoip')
13:25:22.712887 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-freegeoip')
13:25:22.712966 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-freegeoip.data'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/init/ExtensionInit.php
(108)
13:25:22.712970 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-freegeoip.data')
13:25:22.713124 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-freegeoip.data')
13:25:22.713165 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-ipinfodb'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.713170 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-ipinfodb')
13:25:22.713309 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-ipinfodb')
13:25:22.713346 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.backup-manager'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.713351 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.backup-manager')
13:25:22.713495 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.backup-manager')
13:25:22.713536 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.extension.xml'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ExtensionsManager.php
(172)
13:25:22.713541 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.xml')
13:25:22.713706 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.xml')
13:25:22.713849 trace system.CModule
Loading "themeManager" application component
in /home2/yasfinde/public_html/apps/common/components/init/SystemInit.php
(82)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.715091 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
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/ThemeManager.php
(99)
13:25:22.715097 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')
13:25:22.715301 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')
13:25:22.715720 trace system.CModule
Loading "messages" application component
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.722217 trace system.CModule
Loading "securityManager" application component
in /home2/yasfinde/public_html/apps/frontend/components/web/Controller.php
(29)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.723138 trace system.CModule
Loading "tags" application component
in /home2/yasfinde/public_html/apps/frontend/components/web/Controller.php
(51)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.726778 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='misc'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(10)
13:25:22.726788 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='misc')
13:25:22.727124 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='misc')
13:25:22.727179 trace system.db.CDbCommand
Querying SQL:  SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(22)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(49)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(65)
13:25:22.727184 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false)
13:25:22.729087 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false)
13:25:22.729132 trace system.db.CDbCommand
Querying SQL: SELECT  tdata.message,translate.source_tag FROM
`mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1'
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(31)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(49)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(65)
13:25:22.729140 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT  tdata.message,translate.source_tag
FROM `mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1')
13:25:22.729512 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT  tdata.message,translate.source_tag
FROM `mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1')
13:25:22.738594 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `mw_countries`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/Countries.php (106)
in /home2/yasfinde/public_html/apps/common/models/Countries.php (259)
13:25:22.738604 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_countries`)
13:25:22.739852 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_countries`)
13:25:22.740917 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `mw_countries`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/Countries.php (106)
in /home2/yasfinde/public_html/apps/common/models/Countries.php (259)
13:25:22.740926 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_countries`)
13:25:22.741203 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_countries`)
13:25:22.745827 trace system.db.ar.CActiveRecord
Countries.findAll()
in /home2/yasfinde/public_html/apps/common/models/Countries.php (397)
in /home2/yasfinde/public_html/apps/frontend/components/web/Controller.php
(63)
in /home2/yasfinde/public_html/apps/init.php (200)
13:25:22.747915 trace system.db.CDbCommand
Querying SQL: SELECT
t.country_name,t.country_id,priority,enable_all_cities,show_region,slug,cords
FROM `mw_countries` `t` WHERE (t.show_on_listing=:ycp0) AND
(t.isTrash=:ycp1) ORDER BY -t.priority desc , country_name asc. Bound with
:ycp0='1', :ycp1='0'
in /home2/yasfinde/public_html/apps/common/models/Countries.php (397)
in /home2/yasfinde/public_html/apps/frontend/components/web/Controller.php
(63)
in /home2/yasfinde/public_html/apps/init.php (200)
13:25:22.747924 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
t.country_name,t.country_id,priority,enable_all_cities,show_region,slug,cords
FROM `mw_countries` `t` WHERE (t.show_on_listing=:ycp0) AND
(t.isTrash=:ycp1) ORDER BY -t.priority desc , country_name asc. Bound with
:ycp0='1', :ycp1='0')
13:25:22.749241 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
t.country_name,t.country_id,priority,enable_all_cities,show_region,slug,cords
FROM `mw_countries` `t` WHERE (t.show_on_listing=:ycp0) AND
(t.isTrash=:ycp1) ORDER BY -t.priority desc , country_name asc. Bound with
:ycp0='1', :ycp1='0')
13:25:22.997576 trace system.CModule
Loading "statePersister" application component
in /home2/yasfinde/public_html/apps/frontend/components/web/Controller.php
(88)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
13:25:22.998497 trace application
Did frontend_controller_before_action action, 1 action hooks were
triggered!
in
/home2/yasfinde/public_html/apps/common/components/managers/HooksManager.php
(125)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(124)
in /home2/yasfinde/public_html/apps/frontend/components/web/Controller.php
(127)
13:25:22.998585 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.home'
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(162)
in
/home2/yasfinde/public_html/apps/common/components/managers/OptionsManager.php
(73)
in /home2/yasfinde/public_html/apps/frontend/controllers/SiteController.php
(19)
13:25:22.998593 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.home')
13:25:22.999100 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.home')
13:25:22.999177 trace system.db.CDbCommand
Querying SQL:  SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(22)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(49)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(65)
13:25:22.999183 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false)
13:25:23.006542 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false)
13:25:23.006618 trace system.db.CDbCommand
Querying SQL: SELECT  tdata.message,translate.source_tag FROM
`mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1'
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(31)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(49)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(65)
13:25:23.006625 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT  tdata.message,translate.source_tag
FROM `mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1')
13:25:23.007256 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT  tdata.message,translate.source_tag
FROM `mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1')
13:25:23.007344 trace system.CModule
Loading "clientScript" application component
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(172)
in /home2/yasfinde/public_html/apps/frontend/controllers/SiteController.php
(23)
in /home2/yasfinde/public_html/apps/init.php (200)
13:25:23.009114 trace application
Did register_scripts filter, 1 filter hooks were triggered!
in
/home2/yasfinde/public_html/apps/common/components/managers/HooksManager.php
(329)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(326)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(187)
13:25:23.009170 trace application
Did register_styles filter, 1 filter hooks were triggered!
in
/home2/yasfinde/public_html/apps/common/components/managers/HooksManager.php
(329)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(327)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(187)
13:25:23.020157 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `mw_place_an_ad`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (808)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (805)
13:25:23.020169 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_place_an_ad`)
13:25:23.022546 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_place_an_ad`)
13:25:23.023155 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `mw_place_an_ad`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (808)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (805)
13:25:23.023164 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_place_an_ad`)
13:25:23.024168 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_place_an_ad`)
13:25:23.025259 trace system.CModule
Loading "user" application component
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2306)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(5)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
13:25:23.027509 trace system.CModule
Loading "session" application component
in
/home2/yasfinde/public_html/apps/frontend/components/web/auth/WebCustomer.php
(20)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2306)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(5)
13:25:23.028961 trace system.db.ar.CActiveRecord
PlaceAnAd.findAll()
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(7)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (2)
13:25:23.029109 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.*,featured_plan.plan_id  as
is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueHG ON
featueHG.ad_id = t.id  and featueHG.status = "complete"   left join
mw_featured_plan_items featue_itemsHG ON featue_itemsHG.order_id =
featueHG.order_id  and NOW() >=  featue_itemsHG.from_date    and      NOW()
 <=  featue_itemsHG.to_date  left join mw_featured_plan featured_planHG ON
featured_planHG.plan_id = featue_itemsHG.plan_id and
featured_planHG.category_id = 154  WHERE ((t.isTrash=:ycp2) AND
(t.status=:ycp3)) AND (t.country=:ycp4) and usr.status = "A" and
usr.isTrash="0" and ( t.promoted="1"  or  featured_planHG.plan_id IS NOT
NULL )   ORDER BY t.featured="Y" desc,-t.priority desc , t.id desc  LIMIT
10. Bound with :ycp2='0', :ycp3='A', :ycp4='65946'
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(7)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (2)
13:25:23.029161 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id 
as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueHG ON
featueHG.ad_id = t.id  and featueHG.status = "complete"   left join
mw_featured_plan_items featue_itemsHG ON featue_itemsHG.order_id =
featueHG.order_id  and NOW() >=  featue_itemsHG.from_date    and      NOW()
 <=  featue_itemsHG.to_date  left join mw_featured_plan featured_planHG ON
featured_planHG.plan_id = featue_itemsHG.plan_id and
featured_planHG.category_id = 154  WHERE ((t.isTrash=:ycp2) AND
(t.status=:ycp3)) AND (t.country=:ycp4) and usr.status = "A" and
usr.isTrash="0" and ( t.promoted="1"  or  featured_planHG.plan_id IS NOT
NULL )   ORDER BY t.featured="Y" desc,-t.priority desc , t.id desc  LIMIT
10. Bound with :ycp2='0', :ycp3='A', :ycp4='65946')
13:25:23.106503 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id 
as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueHG ON
featueHG.ad_id = t.id  and featueHG.status = "complete"   left join
mw_featured_plan_items featue_itemsHG ON featue_itemsHG.order_id =
featueHG.order_id  and NOW() >=  featue_itemsHG.from_date    and      NOW()
 <=  featue_itemsHG.to_date  left join mw_featured_plan featured_planHG ON
featured_planHG.plan_id = featue_itemsHG.plan_id and
featured_planHG.category_id = 154  WHERE ((t.isTrash=:ycp2) AND
(t.status=:ycp3)) AND (t.country=:ycp4) and usr.status = "A" and
usr.isTrash="0" and ( t.promoted="1"  or  featured_planHG.plan_id IS NOT
NULL )   ORDER BY t.featured="Y" desc,-t.priority desc , t.id desc  LIMIT
10. Bound with :ycp2='0', :ycp3='A', :ycp4='65946')
13:25:23.107865 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(60)
13:25:23.107939 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(60)
13:25:23.107944 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.108480 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.108683 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(60)
13:25:23.108730 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(60)
13:25:23.108735 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.108962 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.109205 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(60)
13:25:23.109249 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_gallery.php
(60)
13:25:23.109252 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.109458 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.110131 trace system.db.ar.CActiveRecord
PlaceAnAd.findAll()
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (8)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (3)
13:25:23.110189 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.*,featured_plan.plan_id  as
is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueT ON
featueT.ad_id = t.id  and featueT.status = "complete"   left join
mw_featured_plan_items featue_itemsT ON featue_itemsT.order_id =
featueT.order_id  and NOW() >=  featue_itemsT.from_date    and      NOW() 
<=  featue_itemsT.to_date  left join mw_featured_plan featured_planT ON
featured_planT.plan_id = featue_itemsT.plan_id and
featured_planT.category_id = 151  WHERE ((t.isTrash=:ycp5) AND
(t.status=:ycp6)) AND (t.country=:ycp7) and usr.status = "A" and
usr.isTrash="0" and (    t.recmnded="1" or  featured_planT.plan_id IS NOT
NULL )  and t.section_id != 4  ORDER BY t.featured="Y" desc,-t.priority
desc , t.id desc  LIMIT 10. Bound with :ycp5='0', :ycp6='A', :ycp7='65946'
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (8)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (3)
13:25:23.110194 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id 
as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueT ON
featueT.ad_id = t.id  and featueT.status = "complete"   left join
mw_featured_plan_items featue_itemsT ON featue_itemsT.order_id =
featueT.order_id  and NOW() >=  featue_itemsT.from_date    and      NOW() 
<=  featue_itemsT.to_date  left join mw_featured_plan featured_planT ON
featured_planT.plan_id = featue_itemsT.plan_id and
featured_planT.category_id = 151  WHERE ((t.isTrash=:ycp5) AND
(t.status=:ycp6)) AND (t.country=:ycp7) and usr.status = "A" and
usr.isTrash="0" and (    t.recmnded="1" or  featured_planT.plan_id IS NOT
NULL )  and t.section_id != 4  ORDER BY t.featured="Y" desc,-t.priority
desc , t.id desc  LIMIT 10. Bound with :ycp5='0', :ycp6='A', :ycp7='65946')
13:25:23.155329 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id 
as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueT ON
featueT.ad_id = t.id  and featueT.status = "complete"   left join
mw_featured_plan_items featue_itemsT ON featue_itemsT.order_id =
featueT.order_id  and NOW() >=  featue_itemsT.from_date    and      NOW() 
<=  featue_itemsT.to_date  left join mw_featured_plan featured_planT ON
featured_planT.plan_id = featue_itemsT.plan_id and
featured_planT.category_id = 151  WHERE ((t.isTrash=:ycp5) AND
(t.status=:ycp6)) AND (t.country=:ycp7) and usr.status = "A" and
usr.isTrash="0" and (    t.recmnded="1" or  featured_planT.plan_id IS NOT
NULL )  and t.section_id != 4  ORDER BY t.featured="Y" desc,-t.priority
desc , t.id desc  LIMIT 10. Bound with :ycp5='0', :ycp6='A', :ycp7='65946')
13:25:23.158829 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.158901 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.158906 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.159269 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.159605 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.159651 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.159657 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.160073 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.160420 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.160468 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.160471 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.160649 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.161108 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.161159 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.161164 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.163609 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.163948 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.164005 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.164011 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.164294 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.164498 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.164542 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.164546 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.173631 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.174124 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.174197 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.174202 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.174537 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.174783 trace system.db.ar.CActiveRecord
Countries.find()
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.174845 trace system.db.CDbCommand
Querying SQL: SELECT cn.code FROM `mw_countries` `t`  LEFT JOIN 
mw_currency cn ON cn.currency_id = t.default_currency  WHERE t.country_id
=:country  LIMIT 1. Bound with :country='65946'
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (667)
in /home2/yasfinde/public_html/apps/common/models/PlaceAnAd.php (2708)
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_pic.php (59)
13:25:23.174850 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` 
LEFT JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.175028 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t`  LEFT
JOIN  mw_currency cn ON cn.currency_id = t.default_currency  WHERE
t.country_id =:country  LIMIT 1. Bound with :country='65946')
13:25:23.175553 trace system.db.ar.CActiveRecord
PlaceAnAd.findAll()
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_jobs.php (7)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (4)
13:25:23.175626 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.*,featured_plan.plan_id  as
is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueT ON
featueT.ad_id = t.id  and featueT.status = "complete"   left join
mw_featured_plan_items featue_itemsT ON featue_itemsT.order_id =
featueT.order_id  and NOW() >=  featue_itemsT.from_date    and      NOW() 
<=  featue_itemsT.to_date  left join mw_featured_plan featured_planT ON
featured_planT.plan_id = featue_itemsT.plan_id and
featured_planT.category_id = 151  WHERE ((t.isTrash=:ycp8) AND
(t.status=:ycp9)) AND (t.country=:ycp10) and usr.status = "A" and
usr.isTrash="0" and (    t.recmnded="1" or  featured_planT.plan_id IS NOT
NULL )  and t.section_id =:new_section_id  ORDER BY t.featured="Y"
desc,-t.priority desc , t.id desc  LIMIT 10. Bound with :ycp8='0',
:ycp9='A', :ycp10='65946', :new_section_id='4'
in /home2/yasfinde/public_html/apps/frontend/views/site/_top_jobs.php (7)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (4)
13:25:23.175631 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id 
as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueT ON
featueT.ad_id = t.id  and featueT.status = "complete"   left join
mw_featured_plan_items featue_itemsT ON featue_itemsT.order_id =
featueT.order_id  and NOW() >=  featue_itemsT.from_date    and      NOW() 
<=  featue_itemsT.to_date  left join mw_featured_plan featured_planT ON
featured_planT.plan_id = featue_itemsT.plan_id and
featured_planT.category_id = 151  WHERE ((t.isTrash=:ycp8) AND
(t.status=:ycp9)) AND (t.country=:ycp10) and usr.status = "A" and
usr.isTrash="0" and (    t.recmnded="1" or  featured_planT.plan_id IS NOT
NULL )  and t.section_id =:new_section_id  ORDER BY t.featured="Y"
desc,-t.priority desc , t.id desc  LIMIT 10. Bound with :ycp8='0',
:ycp9='A', :ycp10='65946', :new_section_id='4')
13:25:23.226641 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id 
as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, 
sub.category_name as s_category_name, lst.category_name as
lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM
mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0" limit 1 )   as ad_image,usr.image as
user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no 
,usr.company_name as company_name  ,usr.company_logo as
company_logo,usr.user_type as user_type,usr.featured as
user_verified,cn.country_name,cn.cords,(SELECT  group_concat(`image_name`) 
FROM mw_ad_image img  WHERE  img.ad_id = t.id and  img.status="A" and 
img.isTrash="0"    )   as ad_images_g,cat.category_name as 
category_name,st.state_name as state_name,ct.city_name ,
sec.section_name,ad_title as    ad_title2   FROM `mw_place_an_ad` `t`  left
join mw_feature_plan_order featue ON featue.ad_id = t.id   and
featue.status = "complete"   left join mw_featured_plan_items featue_items
ON featue_items.order_id = featue.order_id  and NOW() >= 
featue_items.from_date    and      NOW()  <=  featue_items.to_date  left
join mw_featured_plan featured_plan ON featured_plan.plan_id =
featue_items.plan_id and featured_plan.category_id = 153  left join
mw_countries cn ON cn.country_id = t.country  left join mw_category lst ON
lst.category_id = t.listing_type  left join mw_category sub ON
sub.category_id = t.sub_category  left join mw_category cat ON
cat.category_id = t.category_id  left join mw_states st ON st.state_id =
t.state  left join mw_city ct ON ct.city_id = t.city  left join mw_section
sec ON sec.section_id = t.section_id  INNER JOIN mw_listing_users usr on
usr.user_id = t.user_id  left join mw_feature_plan_order featueT ON
featueT.ad_id = t.id  and featueT.status = "complete"   left join
mw_featured_plan_items featue_itemsT ON featue_itemsT.order_id =
featueT.order_id  and NOW() >=  featue_itemsT.from_date    and      NOW() 
<=  featue_itemsT.to_date  left join mw_featured_plan featured_planT ON
featured_planT.plan_id = featue_itemsT.plan_id and
featured_planT.category_id = 151  WHERE ((t.isTrash=:ycp8) AND
(t.status=:ycp9)) AND (t.country=:ycp10) and usr.status = "A" and
usr.isTrash="0" and (    t.recmnded="1" or  featured_planT.plan_id IS NOT
NULL )  and t.section_id =:new_section_id  ORDER BY t.featured="Y"
desc,-t.priority desc , t.id desc  LIMIT 10. Bound with :ycp8='0',
:ycp9='A', :ycp10='65946', :new_section_id='4')
13:25:23.227778 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `mw_category`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (111)
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (170)
13:25:23.227787 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_category`)
13:25:23.228962 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_category`)
13:25:23.229154 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `mw_category`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (111)
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (170)
13:25:23.229161 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_category`)
13:25:23.229490 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_category`)
13:25:23.229815 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (392)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (5)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
13:25:23.229903 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,sub_image
FROM `mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id
= t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C' and t.featured='1' and t.sub_image is not null   ORDER BY
-t.priority desc,category_name asc . Bound with :section=2
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (392)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (5)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
13:25:23.229909 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,sub_image FROM `mw_category` `t`  INNER
JOIN mw_listing_section ls on ls.category_id = t.category_id and
ls.section_id =  :section  WHERE t.isTrash='0' and t.f_type='C' and
t.featured='1' and t.sub_image is not null   ORDER BY -t.priority
desc,category_name asc . Bound with :section=2)
13:25:23.231343 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,sub_image FROM `mw_category` `t`  INNER
JOIN mw_listing_section ls on ls.category_id = t.category_id and
ls.section_id =  :section  WHERE t.isTrash='0' and t.f_type='C' and
t.featured='1' and t.sub_image is not null   ORDER BY -t.priority
desc,category_name asc . Bound with :section=2)
13:25:23.232186 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (392)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (54)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
13:25:23.232266 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,sub_image
FROM `mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id
= t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C' and t.featured='1' and t.sub_image is not null   ORDER BY
-t.priority desc,category_name asc . Bound with :section=1
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (392)
in /home2/yasfinde/public_html/apps/frontend/views/site/index.php (54)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
13:25:23.232273 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,sub_image FROM `mw_category` `t`  INNER
JOIN mw_listing_section ls on ls.category_id = t.category_id and
ls.section_id =  :section  WHERE t.isTrash='0' and t.f_type='C' and
t.featured='1' and t.sub_image is not null   ORDER BY -t.priority
desc,category_name asc . Bound with :section=1)
13:25:23.233059 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,sub_image FROM `mw_category` `t`  INNER
JOIN mw_listing_section ls on ls.category_id = t.category_id and
ls.section_id =  :section  WHERE t.isTrash='0' and t.f_type='C' and
t.featured='1' and t.sub_image is not null   ORDER BY -t.priority
desc,category_name asc . Bound with :section=1)
13:25:23.236242 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `mw_section`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/Section.php (129)
in /home2/yasfinde/public_html/apps/common/models/Section.php (148)
13:25:23.236253 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_section`)
13:25:23.237474 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_section`)
13:25:23.237626 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `mw_section`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/Section.php (129)
in /home2/yasfinde/public_html/apps/common/models/Section.php (148)
13:25:23.237634 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_section`)
13:25:23.237833 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_section`)
13:25:23.238064 trace system.db.ar.CActiveRecord
Section.findAll()
in /home2/yasfinde/public_html/apps/common/models/Section.php (162)
in /home2/yasfinde/public_html/apps/common/models/Section.php (363)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.238122 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_section` `t` ORDER BY priority asc
in /home2/yasfinde/public_html/apps/common/models/Section.php (162)
in /home2/yasfinde/public_html/apps/common/models/Section.php (363)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.238128 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_section` `t` ORDER BY
priority asc)
13:25:23.238437 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_section` `t` ORDER BY
priority asc)
13:25:23.239227 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.239296 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,popular FROM
`mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id =
t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='1'
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.239303 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='1')
13:25:23.240654 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='1')
13:25:23.242757 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.242835 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,popular FROM
`mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id =
t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='2'
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.242841 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='2')
13:25:23.243510 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='2')
13:25:23.244175 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.244220 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,popular FROM
`mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id =
t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='3'
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.244224 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='3')
13:25:23.245069 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='3')
13:25:23.245286 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.245327 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,popular FROM
`mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id =
t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='4'
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.245331 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='4')
13:25:23.245932 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='4')
13:25:23.248645 trace system.db.ar.CActiveRecord
Category.findAll()
in /home2/yasfinde/public_html/apps/common/models/Category.php (493)
in /home2/yasfinde/public_html/apps/common/models/Section.php (376)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.248712 trace system.db.CDbCommand
Querying SQL: SELECT t.category_id,category_name,slug FROM `mw_category`
`t`  INNER JOIN mw_listing_type_filelds flds on flds.category_id =
t.category_id and flds.listing_type = :section  WHERE t.isTrash='0'   ORDER
BY -t.priority desc,category_name asc . Bound with :section='850'
in /home2/yasfinde/public_html/apps/common/models/Category.php (493)
in /home2/yasfinde/public_html/apps/common/models/Section.php (376)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.248716 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT t.category_id,category_name,slug
FROM `mw_category` `t`  INNER JOIN mw_listing_type_filelds flds on
flds.category_id = t.category_id and flds.listing_type = :section  WHERE
t.isTrash='0'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='850')
13:25:23.249275 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT t.category_id,category_name,slug FROM
`mw_category` `t`  INNER JOIN mw_listing_type_filelds flds on
flds.category_id = t.category_id and flds.listing_type = :section  WHERE
t.isTrash='0'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='850')
13:25:23.249309 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.249355 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,popular FROM
`mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id =
t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='9'
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.249357 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='9')
13:25:23.249896 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='9')
13:25:23.250853 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.250896 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,popular FROM
`mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id =
t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='10'
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.250900 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='10')
13:25:23.251579 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='10')
13:25:23.252463 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.252504 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,popular FROM
`mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id =
t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='11'
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.252510 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='11')
13:25:23.253076 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='11')
13:25:23.253345 trace system.db.ar.CActiveRecord
MainCategory.findAll()
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.253382 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT t.category_id,category_name,slug,popular FROM
`mw_category` `t`  INNER JOIN mw_listing_section ls on ls.category_id =
t.category_id and ls.section_id =  :section  WHERE t.isTrash='0' and
t.f_type='C'   ORDER BY -t.priority desc,category_name asc . Bound with
:section='12'
in /home2/yasfinde/public_html/apps/common/models/MainCategory.php (295)
in /home2/yasfinde/public_html/apps/common/models/Section.php (366)
in /home2/yasfinde/public_html/apps/frontend/views/layouts/_new_header.php
(102)
13:25:23.253386 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='12')
13:25:23.253979 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT DISTINCT
t.category_id,category_name,slug,popular FROM `mw_category` `t`  INNER JOIN
mw_listing_section ls on ls.category_id = t.category_id and ls.section_id =
 :section  WHERE t.isTrash='0' and t.f_type='C'   ORDER BY -t.priority
desc,category_name asc . Bound with :section='12')
13:25:23.256448 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `mw_states`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/States.php (60)
in /home2/yasfinde/public_html/apps/common/models/States.php (156)
13:25:23.256453 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_states`)
13:25:23.257838 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_states`)
13:25:23.257922 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `mw_states`
in
/home2/yasfinde/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(66)
in /home2/yasfinde/public_html/apps/common/models/States.php (60)
in /home2/yasfinde/public_html/apps/common/models/States.php (156)
13:25:23.257929 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_states`)
13:25:23.258208 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_states`)
13:25:23.258363 trace system.db.ar.CActiveRecord
States.findAll()
in /home2/yasfinde/public_html/apps/common/models/States.php (310)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_search.php
(36)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
13:25:23.258420 trace system.db.CDbCommand
Querying SQL: SELECT t.country_id,t.state_id,t.state_name,cn.slug as
country_slug,t.slug,cn.country_name,cn.cords FROM `mw_states` `t` LEFT JOIN
mw_countries cn ON t.country_id  = cn.country_id   WHERE  t.country_id =
:country_id and cn.show_on_listing="1" and case WHEN
cn.enable_all_cities="1" THEN 1  WHEN t.enable_listing="1" THEN 1 ELSE 0
END   . Bound with :country_id='65946'
in /home2/yasfinde/public_html/apps/common/models/States.php (310)
in /home2/yasfinde/public_html/apps/frontend/views/site/_home_search.php
(36)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
13:25:23.258424 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
t.country_id,t.state_id,t.state_name,cn.slug as
country_slug,t.slug,cn.country_name,cn.cords FROM `mw_states` `t` LEFT JOIN
mw_countries cn ON t.country_id  = cn.country_id   WHERE  t.country_id =
:country_id and cn.show_on_listing="1" and case WHEN
cn.enable_all_cities="1" THEN 1  WHEN t.enable_listing="1" THEN 1 ELSE 0
END   . Bound with :country_id='65946')
13:25:23.258982 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
t.country_id,t.state_id,t.state_name,cn.slug as
country_slug,t.slug,cn.country_name,cn.cords FROM `mw_states` `t` LEFT JOIN
mw_countries cn ON t.country_id  = cn.country_id   WHERE  t.country_id =
:country_id and cn.show_on_listing="1" and case WHEN
cn.enable_all_cities="1" THEN 1  WHEN t.enable_listing="1" THEN 1 ELSE 0
END   . Bound with :country_id='65946')
13:25:23.259124 trace system.CModule
Loading "notify" application component
in /home2/yasfinde/public_html/apps/frontend/views/layouts/main.php (69)
in
/home2/yasfinde/public_html/apps/common/components/web/BaseController.php
(245)
in /home2/yasfinde/public_html/apps/frontend/controllers/SiteController.php
(23)
13:25:23.260195 trace system.db.CDbCommand
Querying SQL:  SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(22)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(49)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(65)
13:25:23.260200 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false)
13:25:23.262238 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false)
13:25:23.262283 trace system.db.CDbCommand
Querying SQL: SELECT  tdata.message,translate.source_tag FROM
`mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1'
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(31)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(49)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(65)
13:25:23.262288 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT  tdata.message,translate.source_tag
FROM `mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1')
13:25:23.262978 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT  tdata.message,translate.source_tag
FROM `mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1')
13:25:23.263071 trace system.db.CDbCommand
Querying SQL:  SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(22)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(49)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(65)
13:25:23.263075 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false)
13:25:23.264880 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag ,
translationDatas.message As message  FROM `mw_common_tags` `t` INNER JOIN
`mw_translate_relation` `translateRelations` ON
(`translateRelations`.`tag_id`=`t`.`id`)  INNER JOIN `mw_translation_data`
`translationDatas` ON
(`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) 
AND (`translationDatas`.`lang` =:lan). Bound with :lan=false)
13:25:23.264915 trace system.db.CDbCommand
Querying SQL: SELECT  tdata.message,translate.source_tag FROM
`mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1'
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(31)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(49)
in
/home2/yasfinde/public_html/apps/common/components/managers/TagsManager.php
(65)
13:25:23.264919 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT  tdata.message,translate.source_tag
FROM `mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1')
13:25:23.265247 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT  tdata.message,translate.source_tag
FROM `mw_translate_relation` `translationRelation` INNER  JOIN
mw_translation_data tdata ON
(`translationRelation`.translate_id=tdata.translation_id and
tdata.lang=:lan)  INNER JOIN mw_translate translate ON
(`translationRelation`.translate_id=translate.translate_id) WHERE
(`translationRelation`.`common_id`=:common_id) . Bound with :lan=false,
:common_id='1')
13:25:23.265418 trace system.CModule
Loading "assetManager" application component
in /home2/yasfinde/public_html/apps/frontend/controllers/SiteController.php
(23)
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)
Profiling Summary Report (Time: 0.60622s, Memory: 8,461KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, sub.category_name as s_category_name, lst.category_name as lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM mw_ad_image img WHERE img.ad_id = t.id and img.status="A" and img.isTrash="0" limit 1 ) as ad_image,usr.image as user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no ,usr.company_name as company_name ,usr.company_logo as company_logo,usr.user_type as user_type,usr.featured as user_verified,cn.country_name,cn.cords,(SELECT group_concat(`image_name`) FROM mw_ad_image img WHERE img.ad_id = t.id and img.status="A" and img.isTrash="0" ) as ad_images_g,cat.category_name as category_name,st.state_name as state_name,ct.city_name , sec.section_name,ad_title as ad_title2 FROM `mw_place_an_ad` `t` left join mw_feature_plan_order featue ON featue.ad_id = t.id and featue.status = "complete" left join mw_featured_plan_items featue_items ON featue_items.order_id = featue.order_id and NOW() >= featue_items.from_date and NOW() <= featue_items.to_date left join mw_featured_plan featured_plan ON featured_plan.plan_id = featue_items.plan_id and featured_plan.category_id = 153 left join mw_countries cn ON cn.country_id = t.country left join mw_category lst ON lst.category_id = t.listing_type left join mw_category sub ON sub.category_id = t.sub_category left join mw_category cat ON cat.category_id = t.category_id left join mw_states st ON st.state_id = t.state left join mw_city ct ON ct.city_id = t.city left join mw_section sec ON sec.section_id = t.section_id INNER JOIN mw_listing_users usr on usr.user_id = t.user_id left join mw_feature_plan_order featueHG ON featueHG.ad_id = t.id and featueHG.status = "complete" left join mw_featured_plan_items featue_itemsHG ON featue_itemsHG.order_id = featueHG.order_id and NOW() >= featue_itemsHG.from_date and NOW() <= featue_itemsHG.to_date left join mw_featured_plan featured_planHG ON featured_planHG.plan_id = featue_itemsHG.plan_id and featured_planHG.category_id = 154 WHERE ((t.isTrash=:ycp2) AND (t.status=:ycp3)) AND (t.country=:ycp4) and usr.status = "A" and usr.isTrash="0" and ( t.promoted="1" or featured_planHG.plan_id IS NOT NULL ) ORDER BY t.featured="Y" desc,-t.priority desc , t.id desc LIMIT 10. Bound with :ycp2='0', :ycp3='A', :ycp4='65946') 1 0.07734 0.07734 0.07734 0.07734
system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, sub.category_name as s_category_name, lst.category_name as lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM mw_ad_image img WHERE img.ad_id = t.id and img.status="A" and img.isTrash="0" limit 1 ) as ad_image,usr.image as user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no ,usr.company_name as company_name ,usr.company_logo as company_logo,usr.user_type as user_type,usr.featured as user_verified,cn.country_name,cn.cords,(SELECT group_concat(`image_name`) FROM mw_ad_image img WHERE img.ad_id = t.id and img.status="A" and img.isTrash="0" ) as ad_images_g,cat.category_name as category_name,st.state_name as state_name,ct.city_name , sec.section_name,ad_title as ad_title2 FROM `mw_place_an_ad` `t` left join mw_feature_plan_order featue ON featue.ad_id = t.id and featue.status = "complete" left join mw_featured_plan_items featue_items ON featue_items.order_id = featue.order_id and NOW() >= featue_items.from_date and NOW() <= featue_items.to_date left join mw_featured_plan featured_plan ON featured_plan.plan_id = featue_items.plan_id and featured_plan.category_id = 153 left join mw_countries cn ON cn.country_id = t.country left join mw_category lst ON lst.category_id = t.listing_type left join mw_category sub ON sub.category_id = t.sub_category left join mw_category cat ON cat.category_id = t.category_id left join mw_states st ON st.state_id = t.state left join mw_city ct ON ct.city_id = t.city left join mw_section sec ON sec.section_id = t.section_id INNER JOIN mw_listing_users usr on usr.user_id = t.user_id left join mw_feature_plan_order featueT ON featueT.ad_id = t.id and featueT.status = "complete" left join mw_featured_plan_items featue_itemsT ON featue_itemsT.order_id = featueT.order_id and NOW() >= featue_itemsT.from_date and NOW() <= featue_itemsT.to_date left join mw_featured_plan featured_planT ON featured_planT.plan_id = featue_itemsT.plan_id and featured_planT.category_id = 151 WHERE ((t.isTrash=:ycp8) AND (t.status=:ycp9)) AND (t.country=:ycp10) and usr.status = "A" and usr.isTrash="0" and ( t.recmnded="1" or featured_planT.plan_id IS NOT NULL ) and t.section_id =:new_section_id ORDER BY t.featured="Y" desc,-t.priority desc , t.id desc LIMIT 10. Bound with :ycp8='0', :ycp9='A', :ycp10='65946', :new_section_id='4') 1 0.05101 0.05101 0.05101 0.05101
system.db.CDbCommand.query(SELECT DISTINCT t.*,featured_plan.plan_id as is_featured_by_order, sec.slug as sec_slug,cat.slug as cat_slug, sub.category_name as s_category_name, lst.category_name as lst_category_name, lst.slug as lst_slug , (SELECT image_name FROM mw_ad_image img WHERE img.ad_id = t.id and img.status="A" and img.isTrash="0" limit 1 ) as ad_image,usr.image as user_image,usr.first_name,usr.last_name ,usr.licence_no as licence_no ,usr.company_name as company_name ,usr.company_logo as company_logo,usr.user_type as user_type,usr.featured as user_verified,cn.country_name,cn.cords,(SELECT group_concat(`image_name`) FROM mw_ad_image img WHERE img.ad_id = t.id and img.status="A" and img.isTrash="0" ) as ad_images_g,cat.category_name as category_name,st.state_name as state_name,ct.city_name , sec.section_name,ad_title as ad_title2 FROM `mw_place_an_ad` `t` left join mw_feature_plan_order featue ON featue.ad_id = t.id and featue.status = "complete" left join mw_featured_plan_items featue_items ON featue_items.order_id = featue.order_id and NOW() >= featue_items.from_date and NOW() <= featue_items.to_date left join mw_featured_plan featured_plan ON featured_plan.plan_id = featue_items.plan_id and featured_plan.category_id = 153 left join mw_countries cn ON cn.country_id = t.country left join mw_category lst ON lst.category_id = t.listing_type left join mw_category sub ON sub.category_id = t.sub_category left join mw_category cat ON cat.category_id = t.category_id left join mw_states st ON st.state_id = t.state left join mw_city ct ON ct.city_id = t.city left join mw_section sec ON sec.section_id = t.section_id INNER JOIN mw_listing_users usr on usr.user_id = t.user_id left join mw_feature_plan_order featueT ON featueT.ad_id = t.id and featueT.status = "complete" left join mw_featured_plan_items featue_itemsT ON featue_itemsT.order_id = featueT.order_id and NOW() >= featue_itemsT.from_date and NOW() <= featue_itemsT.to_date left join mw_featured_plan featured_planT ON featured_planT.plan_id = featue_itemsT.plan_id and featured_planT.category_id = 151 WHERE ((t.isTrash=:ycp5) AND (t.status=:ycp6)) AND (t.country=:ycp7) and usr.status = "A" and usr.isTrash="0" and ( t.recmnded="1" or featured_planT.plan_id IS NOT NULL ) and t.section_id != 4 ORDER BY t.featured="Y" desc,-t.priority desc , t.id desc LIMIT 10. Bound with :ycp5='0', :ycp6='A', :ycp7='65946') 1 0.04514 0.04514 0.04514 0.04514
system.db.CDbCommand.query(SELECT cn.code FROM `mw_countries` `t` LEFT JOIN mw_currency cn ON cn.currency_id = t.default_currency WHERE t.country_id =:country LIMIT 1. Bound with :country='65946') 11 0.01425 0.00130 0.00018 0.00908
system.db.CDbCommand.query( SELECT `t`.`conversion_tag` AS tag , translationDatas.message As message FROM `mw_common_tags` `t` INNER JOIN `mw_translate_relation` `translateRelations` ON (`translateRelations`.`tag_id`=`t`.`id`) INNER JOIN `mw_translation_data` `translationDatas` ON (`translationDatas`.`translation_id`=`translateRelations`.`translate_id`) AND (`translationDatas`.`lang` =:lan). Bound with :lan=false) 4 0.01310 0.00328 0.00181 0.00736
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_place_an_ad`) 1 0.00238 0.00238 0.00238 0.00238
system.db.CDbCommand.query(SELECT tdata.message,translate.source_tag FROM `mw_translate_relation` `translationRelation` INNER JOIN mw_translation_data tdata ON (`translationRelation`.translate_id=tdata.translation_id and tdata.lang=:lan) INNER JOIN mw_translate translate ON (`translationRelation`.translate_id=translate.translate_id) WHERE (`translationRelation`.`common_id`=:common_id) . Bound with :lan=false, :common_id='1') 4 0.00202 0.00051 0.00033 0.00069
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,sub_image FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' and t.featured='1' and t.sub_image is not null ORDER BY -t.priority desc,category_name asc . Bound with :section=2) 1 0.00143 0.00143 0.00143 0.00143
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_states`) 1 0.00138 0.00138 0.00138 0.00138
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,popular FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' ORDER BY -t.priority desc,category_name asc . Bound with :section='1') 1 0.00135 0.00135 0.00135 0.00135
system.db.CDbCommand.query(SELECT t.country_name,t.country_id,priority,enable_all_cities,show_region,slug,cords FROM `mw_countries` `t` WHERE (t.show_on_listing=:ycp0) AND (t.isTrash=:ycp1) ORDER BY -t.priority desc , country_name asc. Bound with :ycp0='1', :ycp1='0') 1 0.00132 0.00132 0.00132 0.00132
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_countries`) 1 0.00125 0.00125 0.00125 0.00125
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_section`) 1 0.00122 0.00122 0.00122 0.00122
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_category`) 1 0.00117 0.00117 0.00117 0.00117
system.db.CDbCommand.query(SHOW CREATE TABLE `mw_place_an_ad`) 1 0.00100 0.00100 0.00100 0.00100
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,popular FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' ORDER BY -t.priority desc,category_name asc . Bound with :section='3') 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,sub_image FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' and t.featured='1' and t.sub_image is not null ORDER BY -t.priority desc,category_name asc . Bound with :section=1) 1 0.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,popular FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' ORDER BY -t.priority desc,category_name asc . Bound with :section='10') 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,popular FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' ORDER BY -t.priority desc,category_name asc . Bound with :section='2') 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,popular FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' ORDER BY -t.priority desc,category_name asc . Bound with :section='4') 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,popular FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' ORDER BY -t.priority desc,category_name asc . Bound with :section='12') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.common') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,popular FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' ORDER BY -t.priority desc,category_name asc . Bound with :section='11') 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT t.category_id,category_name,slug FROM `mw_category` `t` INNER JOIN mw_listing_type_filelds flds on flds.category_id = t.category_id and flds.listing_type = :section WHERE t.isTrash='0' ORDER BY -t.priority desc,category_name asc . Bound with :section='850') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT t.country_id,t.state_id,t.state_name,cn.slug as country_slug,t.slug,cn.country_name,cn.cords FROM `mw_states` `t` LEFT JOIN mw_countries cn ON t.country_id = cn.country_id WHERE t.country_id = :country_id and cn.show_on_listing="1" and case WHEN cn.enable_all_cities="1" THEN 1 WHEN t.enable_listing="1" THEN 1 ELSE 0 END . Bound with :country_id='65946') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT DISTINCT t.category_id,category_name,slug,popular FROM `mw_category` `t` INNER JOIN mw_listing_section ls on ls.category_id = t.category_id and ls.section_id = :section WHERE t.isTrash='0' and t.f_type='C' ORDER BY -t.priority desc,category_name asc . Bound with :section='9') 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.home') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='misc') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE `mw_category`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SELECT * FROM `mw_section` `t` ORDER BY priority asc) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.translate') 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `mw_states`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `mw_countries`) 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.ip-location-telize') 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.urls') 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.payment-gateway-paypal.data') 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.theme.frontend') 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `mw_section`) 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.ip-location-freegeoip') 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.list-form-custom-webhooks') 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.payment-gateway-paypal') 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.translate.data') 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-redirect') 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.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.ip-location-ipinfoio') 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.xml') 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.ip-location-locatorhq') 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.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.extension.ip-location-freegeoip.data') 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.list-form-custom-assets') 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.backup-manager') 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ip-location-ipinfodb') 1 0.00014 0.00014 0.00014 0.00014