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',
)

Loading "log" application component
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)

Loading "systemInit" application component
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)

Loading "frontendSystemInit" application component
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)

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)

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)

Loading "request" application component
in /home2/yasfinde/public_html/apps/init.php (168)
in /home2/yasfinde/public_html/index.php (11)

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)

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)

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)

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)

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.common')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.common')

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)

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.urls')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.urls')

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)

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.translate')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.translate')

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.translate.data')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.translate.data')

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)

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')

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')

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)

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')

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')

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)

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')

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')

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)

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')

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')

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)

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')

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')

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)

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')

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')

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)

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')

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')

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)

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')

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')

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)

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')

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')

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ckeditor')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ckeditor')

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)

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')

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')

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)

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')

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')

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)

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')

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')

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.backup-manager')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.backup-manager')

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.xml')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.xml')

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)

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.theme.frontend')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.theme.frontend')

Loading "messages" application component
in /home2/yasfinde/public_html/apps/init.php (200)
in /home2/yasfinde/public_html/index.php (11)

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)

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)

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='misc')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='misc')

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)

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)

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)

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)

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')

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')

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)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_countries`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_countries`)

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)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_countries`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_countries`)

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)

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)

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')

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')

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)

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)

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)

begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.home')

end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.home')

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)

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)

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)

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)

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')

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')

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)

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)

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)

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)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_place_an_ad`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_place_an_ad`)

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)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_place_an_ad`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_place_an_ad`)

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)

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)

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_category`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_category`)

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)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_category`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_category`)

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)

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)

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)

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)

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)

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)

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)

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)

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)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_section`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_section`)

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)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_section`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_section`)

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)

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)

begin:system.db.CDbCommand.query(SELECT * FROM `mw_section` `t` ORDER BY
priority asc)

end:system.db.CDbCommand.query(SELECT * FROM `mw_section` `t` ORDER BY
priority asc)

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

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)

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')

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')

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)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_states`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `mw_states`)

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)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_states`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `mw_states`)

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)

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)

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')

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')

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)

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)

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)

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)

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)

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')

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')

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)

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)

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)

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)

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')

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')

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)