Sheffield Property Info

See Your Property Here!

Our Featured Property Banner

Click for more info.
Featured Rentals

Featured Rental property in Sheffield

Student Accommodation

Search for Student Property in Sheffield

Houses to Rent

Search for houses to rent in Sheffield

Flats to Rent

Search for flats to rent in Sheffield
Estate Agents & Letting Agents

Find Local Estate & Letting agents in Sheffield.

Conveyancing & Surveyors

Property services companies in Sheffield.

Quick Search

Account Menu

Properties

Newsletters

Array ( [0] => ia.core.sanitize (3.96Kb) [1] => ia.core.validate (4.27Kb) [2] => ia.core.db (24.84Kb) [3] => ia.core.language (4.31Kb) [4] => ia.core.cache (8.51Kb) [5] => ia.core.users (13.52Kb) [6] => ia.core.breadcrumb (4.33Kb) [7] => ia.core.view (48.66Kb) [8] => ia.core.acl (10.67Kb) [9] => ia.core.util (16.07Kb) [10] => ia.core.smarty (8.22Kb) [11] => plugin: ia.front.iaBanner (2.80Kb) [12] => abstractPackageFront (3.18Kb) [13] => package: ia.front.estate (11.89Kb) [14] => abstractPackageAdmin (4.56Kb) [15] => package: ia.common.location (21.88Kb) [16] => ia.core.fields (45.89Kb) [17] => ia.core.item (6.61Kb) )

Array ( [extension] => / [id] => 21 [type] => [url] => [title] => Terms of Use [name] => terms [alias] => [action] => read [extras] => [filename] => page [parent] => [description] => [keywords] => [body] => page [error_404] => [ia_url] => http://sheffieldproperty.info/en/ [admin_url] => http://sheffieldproperty.info/admin/ [subpage] => [css_rendered] => 1 )

Array ( [inventory] => Array ( [0] => inventory ) [mainmenu] => Array ( [0] => main ) [right] => Array ( [0] => account [1] => item_actions [2] => realestate [3] => recent_real_estates [4] => recently_viewed_properties [5] => banner_block_right_1 [6] => newsletters_subscription ) [copyright] => Array ( [0] => bottom ) [account] => Array ( [0] => account_area ) [slider] => Array ( [0] => slider ) [footer1] => Array ( [0] => block_about ) [footer2] => Array ( [0] => block_features ) [footer3] => Array ( [0] => block_about_us ) [footer4] => Array ( [0] => block_contacts ) [left] => Array ( [0] => realestate_quick_search [1] => banner_block_left_1 ) )

Array ( [0] => smartyFrontAfterHeadSection [1] => smartyAdminAfterHeadSection [2] => editItemSetSystemDefaults [3] => phpCoreCodeBeforeStart [4] => frontEditProfile [5] => phpCoreGetUrlBeforeConstantDefine [6] => editProfileExtraTabs [7] => editProfileProcessData [8] => populateCommonStatisticsBlock [9] => phpCoreBeforePageDisplay [10] => phpAdminIndexBeforeStatsGet [11] => smartyAdminIndexAfterStats [12] => phpAdminDatabaseBeforeAll [13] => phpDbControlBeforeReset [14] => adminDatabaseConsistency [15] => phpAdminDatabaseConsistencyType [16] => paymentButtons [17] => phpSmartyAfterFuncInit [18] => smartyFrontBeforeHeadSection )

Array ( [realestate] => Array ( [name] => realestate [url] => http://sheffieldproperty.info/en/ [title] => Real Estate [tpl_url] => http://sheffieldproperty.info/packages/realestate/templates/ [tpl_common] => /var/www/vhosts/sheffieldproperty.info/httpdocs/packages/realestate/templates/common/ ) )

Array ( [bugs_email] => aboldyrev@intelliants.com [debug_pass] => [tmpl] => sheffieldproperty [baseurl] => http://sheffieldproperty.info/ [languages] => a:1:{s:2:"en";s:7:"English";} [backup] => backup/ [version] => 2.3.7 [cron] => 1 [admin_tmpl] => default [default_package] => realestate [ckeditor_color] => #868686 [home_page] => index [tmpl_rollback_data] => a:1:{s:6:"blocks";a:1:{s:17:"common_statistics";a:1:{s:6:"status";s:6:"active";}}} [site] => SheffieldProperty.info for Properties in Sheffield [suffix] => Sheffield Property [site_logo] => site_logo_1a4520475e.jpg [language_switch] => 1 [lang] => en [charset] => UTF-8 [locale] => en_UK [timezone] => Europe/London [date_format] => %b %e, %Y [admin_page] => admin [bc_home] => Home [frontend] => 1 [underconstruction] =>

We are sorry. Our site is under construction.

Sheffield Property Limited is a company
registered in England No: 8792792

[allow_animated_gifs] => 1 [thumb_w] => 80 [thumb_h] => 80 [watermark] => 1 [site_watermark] => [lightbox_name] => prettyphoto [accounts] => 1 [accounts_autoapproval] => 0 [currency] => GBP [balance_min_amount] => 0 [block_positions] => header,top-menu,left,right,contentTop,bottom,user1,user2,verybottom,afterHeader,verytop,copyright,inventory,mainmenu,footer1,footer2,footer3,footer4,slider,testimonials,welcome,tab_popular,tab_new,tab_random,author_info [ckeditor_code_highlighting] => 0 [captcha] => 1 [captcha_name] => kcaptcha [captcha_preview] => [site_from_name] => Sheffield Property Mail [site_email] => info@sheffieldproperty.info [mail_function] => php mail [smtp_auth] => 1 [smtp_server] => tls://smtp.example.org [smtp_port] => [smtp_user] => [smtp_password] => [sendmail_path] => /usr/bin/sendmail [mimetype] => 1 [intelliants_latest_news] => 0 [admin_online_expiry_time] => 180 [display_new_plugins] => 0 [display_feedbacks] => 1 [display_changelog] => 1 [display_twitter] => 1 [twitter_count] => 5 [check_for_updates] => 1 [redirect_time] => 4000 [prevent_csrf] => 1 [caching] => 0 [smarty_cache] => 0 [compress_js] => 0 [account_registration] => 1 [account_registration_subject] => Thanks for registration at {%SITE_NAME%} [account_registration_body] =>

Dear {%FULLNAME%},

Thanks for your registration at {%SITE_URL%}. Here is information you should use in order to login:

Your e-mail: {%EMAIL%}
Your password: {%PASSWORD%}

Your activation key: {%KEY%}

To activate your account go to {%SITE_URL%}confirm/?email={%EMAIL%}&key={%KEY%}
You may change your password later by editing your personal attributes in your account area.

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[account_registration_admin_subject] => Account has been created {%SITE_NAME%} [account_registration_admin_body] =>

Greetings {%FULLNAME%},

Administrator has just created an account for you at {%SITE_URL%}. Here is information you should use in order to login:

Your email: {%EMAIL%}
Your password: {%PASSWORD%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[member_removal] => 1 [member_removal_subject] => Account deleted at {%SITE_NAME%} [member_removal_body] =>

Dear {%FULLNAME%},

Your account was removed from {%SITE_URL%}.

______________________________

Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[password_restoration] => 1 [password_restoration_subject] => Password restoration request at {%SITE_NAME%} [password_restoration_body] =>

Dear {%FULLNAME%},

Please follow this link if you wish change the password at {%SITE_URL%}:
{%URL%}

Or use confirmation code on page: {%SITE_URL%}forgot/?code
E-mail: {%EMAIL%}
Code: {%CODE%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[password_changement] => 1 [password_changement_subject] => Password change request at {%SITE_NAME%} [password_changement_body] =>

Dear {%FULLNAME%},

You requested a password change in {%SITE_NAME%}. Now you should use the following credentials to log in as account:

username: {%USERNAME%}
password: {%PASSWORD%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[account_approved] => 1 [account_approved_subject] => Account was approved at {%SITE_NAME%} [account_approved_body] =>

Dear {%FULLNAME%},

Your account was approved in {%SITE_NAME%}. Now you can log in.

______________________________

Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[account_disapproved] => 1 [account_disapproved_subject] => Account was disapproved at {%SITE_NAME%} [account_disapproved_body] =>

Dear {%FULLNAME%},

Your account was disapproved in {%SITE_NAME%}.

______________________________

Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[estates_locations_browse_type] => grid [estates_footer_locations_num] => 20 [estates_footer_states_num] => 12 [estates_recently_viewed_num] => 10 [estates_popular_num] => 15 [estates_featured_num] => 8 [estates_recent_num] => 10 [estates_addthis_widget] => 1 [estates_gmap_width] => 530 [estates_gmap_height] => 335 [estates_num_per_page] => 10 [estates_rss_entries] => 2000 [estates_location_columns] => 3 [estates_auto_approval] => 0 [sp_right_col] => 1 [sp_left_col] => 1 [sp_social_t] => https://twitter.com/Sheff_Property [sp_social_f] => https://www.facebook.com/pages/Sheffield-Property/365730463544663 [sp_social_g] => https://plus.google.com/+SheffieldPropertyInfo [sp_social_p] => http://pinterest.com/sheffproperty/sheffield-property/ [estates_country_name] => Sheffield, United Kingdom [paypal_currency_code] => GBP [paypal_email] => info@sheffieldproperty.info [paypal_demo] => 0 [captcha_case_sensitive] => 1 [captcha_num_chars] => 8 [prettyphoto_show_title] => 1 [prettyphoto_style] => dark_rounded [prettyphoto_anim_speed] => fast [prettyphoto_socialtools] => ????

[banner_folder] => banners [banner_prefix] => banner_ [banners_payment] => 1 [banners_payment_subject] => Banner was submitted to {own_site} [banners_payment_body] => Dear {admin_name}, Banner has been submitted to {own_site} Directory. Please check it. These are the attributes of a banner: Title: {item_title} URL: {item_url} Email: {item_email} Banner Plan: {item_plan} ______________________________ Thank you, {own_site} Administration Team {own_url} {own_email} [google_langs] => a:55:{s:2:"af";s:9:"Afrikaans";s:2:"sq";s:8:"Albanian";s:2:"ar";s:6:"Arabic";s:2:"be";s:10:"Belarusian";s:2:"bg";s:9:"Bulgarian";s:2:"ca";s:7:"Catalan";s:2:"zh";s:7:"Chinese";s:5:"zh-CN";s:18:"Chinese_simplified";s:5:"zh-TW";s:19:"Chinese_traditional";s:2:"hr";s:8:"Croatian";s:2:"cs";s:5:"Czech";s:2:"da";s:6:"Danish";s:2:"nl";s:5:"Dutch";s:2:"en";s:7:"English";s:2:"et";s:8:"Estonian";s:2:"fi";s:7:"Finnish";s:2:"fr";s:6:"French";s:2:"gl";s:8:"Galician";s:2:"de";s:6:"German";s:2:"el";s:5:"Greek";s:2:"ht";s:14:"Haitian_creole";s:2:"iw";s:6:"Hebrew";s:2:"hi";s:5:"Hindi";s:2:"hu";s:9:"Hungarian";s:2:"is";s:9:"Icelandic";s:2:"id";s:10:"Indonesian";s:2:"ga";s:5:"Irish";s:2:"it";s:7:"Italian";s:2:"ja";s:8:"Japanese";s:2:"ko";s:6:"Korean";s:2:"lv";s:7:"Latvian";s:2:"lt";s:10:"Lithuanian";s:2:"mk";s:10:"Macedonian";s:2:"ms";s:5:"Malay";s:2:"mt";s:7:"Maltese";s:2:"no";s:9:"Norwegian";s:2:"fa";s:7:"Persian";s:2:"pl";s:6:"Polish";s:2:"pt";s:10:"Portuguese";s:5:"pt-PT";s:19:"Portuguese_portugal";s:2:"ro";s:8:"Romanian";s:2:"ru";s:7:"Russian";s:2:"sr";s:7:"Serbian";s:2:"sk";s:6:"Slovak";s:2:"sl";s:9:"Slovenian";s:2:"es";s:7:"Spanish";s:2:"sw";s:7:"Swahili";s:2:"sv";s:7:"Swedish";s:2:"tl";s:7:"Tagalog";s:2:"th";s:4:"Thai";s:2:"tr";s:7:"Turkish";s:2:"uk";s:9:"Ukrainian";s:2:"vi";s:10:"Vietnamese";s:2:"cy";s:5:"Welsh";s:2:"yi";s:7:"Yiddish";} [googletools_analytics] => [googletools_verification] => dYkTRD9Vuq8prZmcypFGJCbOmON0uM0VbQC8egNQjiQ [google_api_key] => AIzaSyAvkUz6hiyP7lXP_YT2RDk9VMPIGNuFa1s [newsletters_items_limit] => 5 [description_chars_num] => 300 [newsletter_subscription] => 1 [newsletter_subscription_subject] => Newsletters from {%SITE_NAME%} [newsletter_subscription_body] =>

Thanks for subscribing to our newsletters at {%SITE_URL%}!

Please go to this page in order to choose topics you want to be subscribed to:

{%SITE_URL%}newsletters/?subscribe={%NEWSLETTERS_TOKEN%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[newsletter_send] => 1 [newsletter_send_subject] => Newsletters from {%SITE_NAME%} [newsletter_send_body] =>

Greetings!

Please check updates at {%SITE_URL%}.

==============================

{%NEWSLETTERS_CONTENT%}

To unsubscribe from the newsletters please use this link.

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[thank_you_for_payment] => Thank you for Payment! [thank_you_for_payment_body] =>

Thanks for your payment at {%SITE_URL%}!

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[favorite_listing_changed] =>

Greetings,

Status of {%LISTING%} has been changed to {%STATUS%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[one_of_favorite_listing_changed] => Status of your favorite listing has been changed. [extrasList] => realestate,paypal,kcaptcha,prettyphoto,banners,services,googletools,mailer,newsletters,importer,sheffieldproperty [estates_block_content] => [estates_display_sold] => 1 )

Array ( [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin [PP_CUSTOM_PHP_INI] => /var/www/vhosts/system/sheffieldproperty.info/etc/php.ini [PP_CUSTOM_PHP_CGI_INDEX] => plesk-php56-fastcgi [SCRIPT_NAME] => /system.php [REQUEST_URI] => /en/terms/ [QUERY_STRING] => _p=system&_p=en/terms/ [REQUEST_METHOD] => GET [SERVER_PROTOCOL] => HTTP/1.0 [GATEWAY_INTERFACE] => CGI/1.1 [REDIRECT_URL] => /en/terms/ [REDIRECT_QUERY_STRING] => _p=en/terms/ [REMOTE_PORT] => 57304 [SCRIPT_FILENAME] => /var/www/vhosts/sheffieldproperty.info/httpdocs/system.php [SERVER_ADMIN] => root@localhost [CONTEXT_DOCUMENT_ROOT] => /var/www/vhosts/sheffieldproperty.info/httpdocs [CONTEXT_PREFIX] => [REQUEST_SCHEME] => http [DOCUMENT_ROOT] => /var/www/vhosts/sheffieldproperty.info/httpdocs [REMOTE_ADDR] => 34.204.185.54 [SERVER_PORT] => 80 [SERVER_ADDR] => 87.239.17.180 [SERVER_NAME] => sheffieldproperty.info [SERVER_SOFTWARE] => Apache [SERVER_SIGNATURE] => [HTTP_ACCEPT_ENCODING] => br,gzip [HTTP_IF_MODIFIED_SINCE] => Wed, 27 Jan 2021 19:40:27 GMT [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/) [HTTP_CONNECTION] => close [HTTP_X_REAL_IP] => 34.204.185.54 [HTTP_HOST] => sheffieldproperty.info [SCRIPT_URI] => http://sheffieldproperty.info/en/terms/ [SCRIPT_URL] => /en/terms/ [UNIQUE_ID] => YHfHB0nFFSih@XuNpZK0YAAAAA0 [REDIRECT_STATUS] => 200 [REDIRECT_SCRIPT_URI] => http://sheffieldproperty.info/en/terms/ [REDIRECT_SCRIPT_URL] => /en/terms/ [REDIRECT_UNIQUE_ID] => YHfHB0nFFSih@XuNpZK0YAAAAA0 [FCGI_ROLE] => RESPONDER [PHP_SELF] => /system.php [REQUEST_TIME_FLOAT] => 1618462471.3289 [REQUEST_TIME] => 1618462471 )

Array ( [error] => Array ( [0] => Unknown error type [8192]: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
on line 76 in file includes/classes/ia.core.mysql.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaCore::factory("core", "db")
on line [71] in file [includes/classes/ia.core.php]

[2] => in class iaDb::init()
on line [676] in file [includes/classes/ia.core.php]

[3] => in class iaDb::_connect()
on line [66] in file [includes/classes/ia.core.mysql.php]

[4] => in function mysql_connect("localhost:3306", "SPadmin", "D4t4b4s3")
on line [76] in file [includes/classes/ia.core.mysql.php]

[5] => in class iaSystem::error(8192, "mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead", "/var/www/vhosts/sheffieldproperty.info/httpdocs/includes/classes/ia.core.mysql.php", 76, array()) ) [1] =>

[2] => Notice: Undefined index: fullname
on line 54 in file tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaView::output()
on line [118] in file [includes/classes/ia.core.php]

[2] => in class iaSmarty::display("layout.tpl")
on line [1504] in file [includes/classes/ia.core.view.php]

[3] => in class Smarty_Internal_TemplateBase::display("/var/www/vhosts/sheffieldproperty.info/httpdocs/templates/sheffieldproperty/layout.tpl", , )
on line [179] in file [includes/classes/ia.core.smarty.php]

[4] => in class Smarty_Internal_TemplateBase::fetch("/var/www/vhosts/sheffieldproperty.info/httpdocs/templates/sheffieldproperty/layout.tpl", , , , true)
on line [344] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[5] => in function content_53f327f29c868(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[6] => in class iaSmartyPlugins::ia_section(array(), object(Smarty_Internal_Template))
on line [238] in file [tmp/front_sheffieldproperty/691904750855e55eb0b17583aaa9d3834b8afe13.file.layout.tpl.php]

[7] => in class Smarty_Internal_TemplateBase::fetch("render-blocks.tpl", "right5822")
on line [806] in file [includes/smarty3/SmartyPlugins.class.php]

[8] => in function content_53f327f2bdc95(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[9] => in class iaSmartyPlugins::blockView(array(), object(Smarty_Internal_Template))
on line [64] in file [tmp/front_sheffieldproperty/f0946515a10848c4d37c7be967f721319dfbf105.file.render-blocks.tpl.php]

[10] => in class Smarty_Internal_TemplateBase::fetch("render-menu.tpl")
on line [120] in file [includes/smarty3/SmartyPlugins.class.php]

[11] => in function content_53f327f2da23b(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[12] => in class iaSystem::error(8, "Undefined index: fullname", "/var/www/vhosts/sheffieldproperty.info/httpdocs/tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php", 54, array())
on line [54] in file [tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php]

) [3] =>

[4] => Notice: Undefined index: username
on line 54 in file tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaView::output()
on line [118] in file [includes/classes/ia.core.php]

[2] => in class iaSmarty::display("layout.tpl")
on line [1504] in file [includes/classes/ia.core.view.php]

[5] => in function content_53f327f29c868(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[7] => in class Smarty_Internal_TemplateBase::fetch("render-blocks.tpl", "right5822")
on line [806] in file [includes/smarty3/SmartyPlugins.class.php]

[8] => in function content_53f327f2bdc95(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[10] => in class Smarty_Internal_TemplateBase::fetch("render-menu.tpl")
on line [120] in file [includes/smarty3/SmartyPlugins.class.php]

[11] => in function content_53f327f2da23b(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[12] => in class iaSystem::error(8, "Undefined index: username", "/var/www/vhosts/sheffieldproperty.info/httpdocs/tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php", 54, array())
on line [54] in file [tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php]

) [5] =>

[6] => Notice: Undefined index: fullname
on line 54 in file tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaView::output()
on line [118] in file [includes/classes/ia.core.php]

[2] => in class iaSmarty::display("layout.tpl")
on line [1504] in file [includes/classes/ia.core.view.php]

[5] => in function content_53f327f29c868(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[7] => in class Smarty_Internal_TemplateBase::fetch("render-blocks.tpl", "right5822")
on line [806] in file [includes/smarty3/SmartyPlugins.class.php]

[8] => in function content_53f327f2bdc95(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[9] => in class iaSmartyPlugins::ia_block(array(), "  <div id="block_account" class="block box movable"> <div id="caption_account" class="box-caption-movable"> <h4>Account Menu</h4> <div class="box-caption-buttons"> </div> </div> <div id="content_account" class="box-content box-content-movable">  <div class="account-panel"> <div class="account-info"> <p> </p> </div> </div>  <ul class="nav nav-actions"> <li class="m_contact_sheffield_property"> <a href="Contact_Sheffield_Property/"> Contact Us </a> </li> <li class="m_sheffield_property_alerts"> <a href="sheffield_property_alerts/"> Property Alerts </a> </li> <li class="m_login"> <a href="login/" rel="nofollow"> Login </a> </li> <li class="m_member_registration"> <a href="registration/" rel="nofollow"> Registration </a> </li> </ul>  </div></div> ", object(Smarty_Internal_Template), false)
on line [66] in file [tmp/front_sheffieldproperty/f0946515a10848c4d37c7be967f721319dfbf105.file.render-blocks.tpl.php]

[10] => in class Smarty_Internal_TemplateBase::fetch("render-menu.tpl")
on line [668] in file [includes/smarty3/SmartyPlugins.class.php]

[11] => in function content_53f327f2da23b(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

) [7] =>

[8] => Notice: Undefined index: username
on line 54 in file tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaView::output()
on line [118] in file [includes/classes/ia.core.php]

[2] => in class iaSmarty::display("layout.tpl")
on line [1504] in file [includes/classes/ia.core.view.php]

[5] => in function content_53f327f29c868(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[7] => in class Smarty_Internal_TemplateBase::fetch("render-blocks.tpl", "right5822")
on line [806] in file [includes/smarty3/SmartyPlugins.class.php]

[8] => in function content_53f327f2bdc95(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[10] => in class Smarty_Internal_TemplateBase::fetch("render-menu.tpl")
on line [668] in file [includes/smarty3/SmartyPlugins.class.php]

[11] => in function content_53f327f2da23b(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

) [9] =>

) )

Time		Sql
Core Queries
0.07 ms	1.	`SET NAMES 'utf8'`
0.11 ms	2.	*SELECT `name`,`code`,`type`,`extras`,`filename`,`pages`,`page_type`,`config` FRO ...* SELECT `name`,`code`,`type`,`extras`,`filename`,`pages`,`page_type`,`config` FROM `sbr237_hooks` WHERE `extras` IN('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty') AND `status` = 'active' ORDER BY `order`
0.26 ms	3.	*SELECT 1 FROM `sbr237_locations` WHERE `url` = 'en/terms/' AND `status` = 'activ ...* SELECT 1 FROM `sbr237_locations` WHERE `url` = 'en/terms/' AND `status` = 'active'
0.19 ms	4.	*SELECT `name` FROM `sbr237_pages` WHERE `alias` = 'en/terms/' AND `status` = 'a ...* SELECT `name` FROM `sbr237_pages` WHERE `alias` = 'en/terms/' AND `status` = 'active' AND `extras` = 'realestate' LIMIT 0, 1
0.27 ms	5.	*SELECT `key`,`value` FROM `sbr237_language` WHERE `code` = 'en' AND `category` ...* SELECT `key`,`value` FROM `sbr237_language` WHERE `code` = 'en' AND `category` != 'tooltip' AND `category` != 'admin' ORDER BY `extras`
0.1 ms	6.	**SELECT FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) ...*** SELECT * FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) OR (`type` = 'group' AND `type_id` = 4)
0.03 ms	7.	*SELECT p.`id`, e.`type`, e.`url`, e.`title`, p.`name`, p.`alias`, p.`action`, p. ...* SELECT p.`id`, e.`type`, e.`url`, e.`title`, p.`name`, p.`alias`, p.`action`, p.`extras`, p.`filename`, p.`parent` , p.`meta_description` `description`, p.`meta_keywords` `keywords` FROM `sbr237_pages` p LEFT JOIN `sbr237_extras` e ON (e.`name` = p.`extras`) WHERE (p.`name` = 'terms' OR p.`alias` = 'terms' OR p.`alias` LIKE 'terms/%') AND p.`status` = 'active' AND (e.`status` = 'active' OR e.`status` IS NULL) ORDER BY LENGTH(p.`alias`) DESC, p.`extras` DESC
0.03 ms	8.	*SELECT `name`,`url`,`title` FROM `sbr237_extras` WHERE `type` = 'package' AND ` ...* SELECT `name`,`url`,`title` FROM `sbr237_extras` WHERE `type` = 'package' AND `status` = 'active'
0.07 ms	9.	**SELECT FROM `sbr237_acl_objects`*** SELECT * FROM `sbr237_acl_objects`
0.03 ms	10.	**SELECT FROM `sbr237_acl_privileges` WHERE (`type` = 'user' AND `type_id` = '0 ...*** SELECT * FROM `sbr237_acl_privileges` WHERE (`type` = 'user' AND `type_id` = '0') OR (`type` = 'group' AND `type_id` = '4')
0.25 ms	11.	**SELECT FROM `sbr237_banners` WHERE `status` = 'active'*** SELECT * FROM `sbr237_banners` WHERE `status` = 'active'
0.04 ms	12.	*SELECT `block_id`,`amount_displayed` FROM `sbr237_banners_block_options`* SELECT `block_id`,`amount_displayed` FROM `sbr237_banners_block_options`
0.05 ms	13.	**SELECT FROM `sbr237_blocks` WHERE `status` = 'active' AND `extras` IN ('', 'r ...*** SELECT * FROM `sbr237_blocks` WHERE `status` = 'active' AND `extras` IN ('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty') ORDER BY `order`
0.03 ms	14.	**SELECT FROM `sbr237_actions` WHERE `status` = 'blocks'*** SELECT * FROM `sbr237_actions` WHERE `status` = 'blocks'
0.03 ms	15.	*SELECT `block_id`,`id` FROM `sbr237_blocks_pages` WHERE `page_name` = 'terms'* SELECT `block_id`,`id` FROM `sbr237_blocks_pages` WHERE `page_name` = 'terms'
0.05 ms	16.	*SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` FROM `sbr237_page ...* SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` FROM `sbr237_pages` WHERE `status` = 'active' AND `extras` IN ('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty')
0.7 ms	17.	**SELECT SQL_CALC_FOUND_ROWS e., l.`url`, l.`title` `location`, (SELECT `title` F ...*** SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` FROM `sbr237_locations` WHERE `id` = t.`parent`) `state` FROM `sbr237_estates` e LEFT JOIN `sbr237_locations` l ON (l.`id` = e.`location_id`) LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = e.`location_id`) WHERE 1 = 1 AND e.`featured` = '1' AND e.`status` IN ('available','sold') ORDER BY RAND() LIMIT 0, 8
0.07 ms	18.	*SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estate ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estates' LIMIT 0, 1
0.03 ms	19.	*SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bathrooms' AND `item` = 'e ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bathrooms' AND `item` = 'estates' LIMIT 0, 1
0.02 ms	20.	*SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bedrooms' AND `item` = 'es ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bedrooms' AND `item` = 'estates' LIMIT 0, 1
0.02 ms	21.	*SELECT `values` FROM `sbr237_fields` WHERE `name` = 'category' AND `item` = 'es ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'category' AND `item` = 'estates' LIMIT 0, 1
1.19 ms	22.	*SELECT d.`title` `title`, d.`url` `url`, p.`code` `abbreviation` FROM `sbr237_lo ...* SELECT d.`title` `title`, d.`url` `url`, p.`code` `abbreviation` FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = d.`id`) LEFT JOIN `sbr237_locations` p ON (t.`parent` = p.`id` AND p.`status` = 'active') WHERE d.`status` = 'active' AND t.`level` > '1' ORDER BY d.`num_listings` DESC, RAND() LIMIT 0, 15
0.05 ms	23.	**SELECT SQL_CALC_FOUND_ROWS e., l.`url`, l.`title` `location`, (SELECT `title` F ...*** SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` FROM `sbr237_locations` WHERE `id` = t.`parent`) `state` FROM `sbr237_estates` e LEFT JOIN `sbr237_locations` l ON (l.`id` = e.`location_id`) LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = e.`location_id`) WHERE 1 = 1 AND e.`status` IN ('available','sold') ORDER BY e.`sponsored` DESC, e.`date_modified` DESC LIMIT 0, 10
0.02 ms	24.	DUPLICATED *SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estate ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estates' LIMIT 0, 1
0.03 ms	25.	DUPLICATED **SELECT SQL_CALC_FOUND_ROWS e., l.`url`, l.`title` `location`, (SELECT `title` F ...*** SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` FROM `sbr237_locations` WHERE `id` = t.`parent`) `state` FROM `sbr237_estates` e LEFT JOIN `sbr237_locations` l ON (l.`id` = e.`location_id`) LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = e.`location_id`) WHERE 1 = 1 AND e.`status` IN ('available','sold') ORDER BY e.`sponsored` DESC, e.`date_modified` DESC LIMIT 0, 10
0.04 ms	26.	**SELECT d. FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...*** SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = d.`id`) WHERE d.`status` = 'active' AND t.`level` > '1' ORDER BY d.`num_listings` DESC LIMIT 0, 20
0.04 ms	27.	DUPLICATED **SELECT d. FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...*** SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = d.`id`) WHERE d.`status` = 'active' AND t.`level` > '1' ORDER BY d.`num_listings` DESC LIMIT 0, 20
0.03 ms	28.	**SELECT d. FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...*** SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = d.`id`) WHERE d.`status` = 'active' AND t.`level` = '1' ORDER BY d.`num_listings` DESC LIMIT 0, 12
0.07 ms	29.	**SELECT FROM `sbr237_accounts` WHERE `featured` = 1*** SELECT * FROM `sbr237_accounts` WHERE `featured` = 1
0.07 ms	30.	**SELECT FROM `sbr237_pages` WHERE `name` = 'terms' AND `status` = 'active' AND ...*** SELECT * FROM `sbr237_pages` WHERE `name` = 'terms' AND `status` = 'active' AND `service` != 1 LIMIT 0, 1
0.03 ms	31.	*SELECT `value` FROM `sbr237_language` WHERE `category` = 'page' AND `key` = 'pa ...* SELECT `value` FROM `sbr237_language` WHERE `category` = 'page' AND `key` = 'page_content_terms' AND `code` = 'en' LIMIT 0, 1
0.07 ms	32.	*SELECT `id`,`name`,`alias`,`nofollow`,`menus`,`group`,`action` FROM `sbr237_page ...* SELECT `id`,`name`,`alias`,`nofollow`,`menus`,`group`,`action` FROM `sbr237_pages` WHERE `status` = 'active' AND `menus` != '' ORDER BY `order`
0.03 ms	33.	DUPLICATED **SELECT FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) ...*** SELECT * FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) OR (`type` = 'group' AND `type_id` = 4)
0.32 ms	34.	*UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '3'* UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '3'
0.15 ms	35.	*UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '2'* UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '2'
0.09 ms	36.	*UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '1'* UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '1'

Time

Sql

Core Queries

0.07 ms

SET NAMES 'utf8'

0.11 ms

SELECT `name`,`code`,`type`,`extras`,`filename`,`pages`,`page_type`,`config` FRO ...

SELECT `name`,`code`,`type`,`extras`,`filename`,`pages`,`page_type`,`config` 
   FROM `sbr237_hooks`  
   WHERE `extras` IN('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty') AND `status` = 'active' 
   ORDER BY `order`

0.26 ms

SELECT 1 FROM `sbr237_locations` WHERE `url` = 'en/terms/' AND `status` = 'activ ...

SELECT 1 
   FROM `sbr237_locations` 
   WHERE `url` = 'en/terms/' AND `status` = 'active'

0.19 ms

SELECT `name` FROM `sbr237_pages` WHERE `alias` = 'en/terms/' AND `status` = 'a ...

SELECT `name` 
   FROM `sbr237_pages`  
   WHERE `alias` = 'en/terms/' AND `status` = 'active' AND `extras` = 'realestate' 
   LIMIT 0, 1

0.27 ms

SELECT `key`,`value` FROM `sbr237_language` WHERE `code` = 'en' AND `category` ...

SELECT `key`,`value` 
   FROM `sbr237_language`  
   WHERE `code` = 'en' AND `category` != 'tooltip' AND `category` != 'admin' 
   ORDER BY `extras`

0.1 ms

SELECT * FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) ...

SELECT * 
   FROM `sbr237_config_custom`  
   WHERE (`type` = 'user' AND `type_id` = 0)  OR (`type` = 'group' AND `type_id` = 4)

0.03 ms

SELECT p.`id`, e.`type`, e.`url`, e.`title`, p.`name`, p.`alias`, p.`action`, p. ...

SELECT p.`id`, e.`type`, e.`url`, e.`title`, p.`name`, p.`alias`, p.`action`, p.`extras`, p.`filename`, p.`parent` , p.`meta_description` `description`, p.`meta_keywords` `keywords` 
   FROM `sbr237_pages` p 
      LEFT JOIN `sbr237_extras` e
         ON (e.`name` = p.`extras`) 
   WHERE (p.`name` = 'terms' OR p.`alias` = 'terms' OR p.`alias` LIKE 'terms/%') AND p.`status` = 'active' AND (e.`status` = 'active' OR e.`status` IS NULL) 
   ORDER BY LENGTH(p.`alias`) DESC, p.`extras` DESC

0.03 ms

SELECT `name`,`url`,`title` FROM `sbr237_extras` WHERE `type` = 'package' AND ` ...

SELECT `name`,`url`,`title` 
   FROM `sbr237_extras`  
   WHERE `type` = 'package' AND `status` = 'active'

0.07 ms

SELECT * FROM `sbr237_acl_objects`

SELECT * 
   FROM `sbr237_acl_objects`

0.03 ms

10.

SELECT * FROM `sbr237_acl_privileges` WHERE (`type` = 'user' AND `type_id` = '0 ...

SELECT * 
   FROM `sbr237_acl_privileges`  
   WHERE (`type` = 'user' AND `type_id` = '0') OR (`type` = 'group' AND `type_id` = '4')

0.25 ms

11.

SELECT * FROM `sbr237_banners` WHERE `status` = 'active'

SELECT * 
   FROM `sbr237_banners`  
   WHERE `status` = 'active'

0.04 ms

12.

SELECT `block_id`,`amount_displayed` FROM `sbr237_banners_block_options`

SELECT `block_id`,`amount_displayed` 
   FROM `sbr237_banners_block_options`

0.05 ms

13.

SELECT * FROM `sbr237_blocks` WHERE `status` = 'active' AND `extras` IN ('', 'r ...

SELECT * 
   FROM `sbr237_blocks`  
   WHERE `status` = 'active' AND `extras` IN ('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty') 
   ORDER BY `order`

0.03 ms

14.

SELECT * FROM `sbr237_actions` WHERE `status` = 'blocks'

SELECT * 
   FROM `sbr237_actions`  
   WHERE `status` = 'blocks'

0.03 ms

15.

SELECT `block_id`,`id` FROM `sbr237_blocks_pages` WHERE `page_name` = 'terms'

SELECT `block_id`,`id` 
   FROM `sbr237_blocks_pages`  
   WHERE `page_name` = 'terms'

0.05 ms

16.

SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` FROM `sbr237_page ...

SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` 
   FROM `sbr237_pages`  
   WHERE `status` = 'active' AND `extras` IN ('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty')

0.7 ms

17.

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` F ...

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` 
   FROM `sbr237_locations` 
   WHERE `id` = t.`parent`) `state`
   FROM `sbr237_estates` e 
      LEFT JOIN `sbr237_locations` l
         ON (l.`id` = e.`location_id`) 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = e.`location_id`) 
   WHERE 1 = 1 AND e.`featured` = '1' AND e.`status` IN ('available','sold') 
   ORDER BY  RAND() 
   LIMIT 0, 8

0.07 ms

18.

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estate ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'type' AND `item` = 'estates' 
   LIMIT 0, 1

0.03 ms

19.

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bathrooms' AND `item` = 'e ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'bathrooms' AND `item` = 'estates' 
   LIMIT 0, 1

0.02 ms

20.

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bedrooms' AND `item` = 'es ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'bedrooms' AND `item` = 'estates' 
   LIMIT 0, 1

0.02 ms

21.

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'category' AND `item` = 'es ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'category' AND `item` = 'estates' 
   LIMIT 0, 1

1.19 ms

22.

SELECT d.`title` `title`, d.`url` `url`, p.`code` `abbreviation` FROM `sbr237_lo ...

SELECT d.`title` `title`, d.`url` `url`, p.`code` `abbreviation` 
   FROM `sbr237_locations` d 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = d.`id`) 
      LEFT JOIN `sbr237_locations` p
         ON (t.`parent` = p.`id` AND p.`status` = 'active') 
   WHERE d.`status` = 'active' AND t.`level` > '1' 
   ORDER BY d.`num_listings` DESC, RAND() 
   LIMIT 0, 15

0.05 ms

23.

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` F ...

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` 
   FROM `sbr237_locations` 
   WHERE `id` = t.`parent`) `state`
   FROM `sbr237_estates` e 
      LEFT JOIN `sbr237_locations` l
         ON (l.`id` = e.`location_id`) 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = e.`location_id`) 
   WHERE 1 = 1 AND e.`status` IN ('available','sold') 
   ORDER BY e.`sponsored` DESC, e.`date_modified` DESC 
   LIMIT 0, 10

0.02 ms

24.

DUPLICATED

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estate ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'type' AND `item` = 'estates' 
   LIMIT 0, 1

0.03 ms

25.

DUPLICATED

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` F ...

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` 
   FROM `sbr237_locations` 
   WHERE `id` = t.`parent`) `state`
   FROM `sbr237_estates` e 
      LEFT JOIN `sbr237_locations` l
         ON (l.`id` = e.`location_id`) 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = e.`location_id`) 
   WHERE 1 = 1 AND e.`status` IN ('available','sold') 
   ORDER BY e.`sponsored` DESC, e.`date_modified` DESC 
   LIMIT 0, 10

0.04 ms

26.

SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...

SELECT d.* 
   FROM `sbr237_locations` d 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = d.`id`)  
   WHERE d.`status` = 'active' AND t.`level` > '1' 
   ORDER BY d.`num_listings` DESC 
   LIMIT 0, 20

0.04 ms

27.

DUPLICATED

SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...

SELECT d.* 
   FROM `sbr237_locations` d 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = d.`id`)  
   WHERE d.`status` = 'active' AND t.`level` > '1' 
   ORDER BY d.`num_listings` DESC 
   LIMIT 0, 20

0.03 ms

28.

SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...

SELECT d.* 
   FROM `sbr237_locations` d 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = d.`id`)  
   WHERE d.`status` = 'active' AND t.`level` = '1' 
   ORDER BY d.`num_listings` DESC 
   LIMIT 0, 12

0.07 ms

29.

SELECT * FROM `sbr237_accounts` WHERE `featured` = 1

SELECT * 
   FROM `sbr237_accounts`  
   WHERE `featured` = 1

0.07 ms

30.

SELECT * FROM `sbr237_pages` WHERE `name` = 'terms' AND `status` = 'active' AND ...

SELECT * 
   FROM `sbr237_pages`  
   WHERE `name` = 'terms' AND `status` = 'active' AND `service` != 1 
   LIMIT 0, 1

0.03 ms

31.

SELECT `value` FROM `sbr237_language` WHERE `category` = 'page' AND `key` = 'pa ...

SELECT `value` 
   FROM `sbr237_language`  
   WHERE `category` = 'page' AND `key` = 'page_content_terms' AND `code` = 'en' 
   LIMIT 0, 1

0.07 ms

32.

SELECT `id`,`name`,`alias`,`nofollow`,`menus`,`group`,`action` FROM `sbr237_page ...

SELECT `id`,`name`,`alias`,`nofollow`,`menus`,`group`,`action` 
   FROM `sbr237_pages`  
   WHERE `status` = 'active' AND `menus` != '' 
   ORDER BY `order`

0.03 ms

33.

DUPLICATED

SELECT * FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) ...

SELECT * 
   FROM `sbr237_config_custom`  
   WHERE (`type` = 'user' AND `type_id` = 0)  OR (`type` = 'group' AND `type_id` = 4)

0.32 ms

34.

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '3'

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' 
   WHERE `id` = '3'

0.15 ms

35.

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '2'

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' 
   WHERE `id` = '2'

0.09 ms

36.

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '1'

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' 
   WHERE `id` = '1'

Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]