По вашему запросу объявлений не найдено. Измените условия сортировки или попробуйте позже, возможно информация по интересующему павильону сейчас обновляется.
config
view
logs
6144.0 KB
174 ms
4
options:
path_info_key: PATH_INFO
path_info_array: SERVER
http_port: null
https_port: null
default_format: null
trust_proxy: true
logging: '1'
relative_url_root: null
formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml }
no_script_name: false
parameterHolder:
action: index
bld: '23'
module: real_estate
type: is_sale
attributeHolder:
sf_route: 'sfRoute Object()'
status:
code: 200
text: OK
options:
http_protocol: HTTP/1.1
logging: '1'
charset: utf-8
send_http_headers: false
content_type: 'text/html; charset=utf-8'
cookies: { }
httpHeaders:
Content-Type: 'text/html; charset=utf-8'
javascripts: { }
stylesheets:
full.min.css: { }
metas:
title: 'Продажа торговой недвижимости в ТЦ «Зеркало»'
description: 'Каталог торговой недвижимости Минска от владельцев. . Удобная фильтрация, актуальные предложения (ежедневное обновление)'
httpMetas:
Content-Type: 'text/html; charset=utf-8'
options:
auto_shutdown: false
culture: null
default_culture: en
use_flash: true
logging: '1'
timeout: 1800
attributeHolder: { }
culture: en
authenticated: false
credentials: { }
lastRequest: 1745955311
mod_real_estate_enabled: true mod_real_estate_view_class: sfPHP sf_admin_module_web_dir: /sfDoctrinePlugin sf_admin_web_dir: /sf/sf_admin sf_app: frontend sf_app_base_cache_dir: /Developers/hosting/helpshop.by/cache/frontend sf_app_cache_dir: /Developers/hosting/helpshop.by/cache/frontend/dev sf_app_config_dir: /Developers/hosting/helpshop.by/apps/frontend/config sf_app_dir: /Developers/hosting/helpshop.by/apps/frontend sf_app_i18n_dir: /Developers/hosting/helpshop.by/apps/frontend/i18n sf_app_lib_dir: /Developers/hosting/helpshop.by/apps/frontend/lib sf_app_module_dir: /Developers/hosting/helpshop.by/apps/frontend/modules sf_app_template_dir: /Developers/hosting/helpshop.by/apps/frontend/templates sf_apps_dir: /Developers/hosting/helpshop.by/apps sf_cache: false sf_cache_dir: /Developers/hosting/helpshop.by/cache sf_charset: utf-8 sf_check_lock: false sf_cli: false sf_compressed: false sf_config_cache_dir: /Developers/hosting/helpshop.by/cache/frontend/dev/config sf_config_dir: /Developers/hosting/helpshop.by/config sf_csrf_secret: 90017390434dfd4c5c0265305844e1e254e82cf7 sf_data_dir: /Developers/hosting/helpshop.by/data sf_debug: true sf_default_culture: en sf_enabled_modules: - default sf_environment: dev sf_error_404_action: error404 sf_error_404_module: errors sf_error_500_action: error500 sf_error_500_module: errors sf_error_reporting: 32767 sf_escaping_method: ESC_SPECIALCHARS sf_escaping_strategy: true sf_etag: false sf_file_link_format: null sf_i18n: false sf_i18n_cache_dir: /Developers/hosting/helpshop.by/cache/frontend/dev/i18n sf_lib_dir: /Developers/hosting/helpshop.by/lib sf_log_dir: /Developers/hosting/helpshop.by/log sf_logging_enabled: true sf_login_action: login sf_login_module: default sf_module_cache_dir: /Developers/hosting/helpshop.by/cache/frontend/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: false sf_orm: doctrine sf_plugins_dir: /Developers/hosting/helpshop.by/plugins sf_psr_logger: false sf_root_dir: /Developers/hosting/helpshop.by sf_secure_action: error403 sf_secure_module: errors sf_sfSelect2Widgets_available_cultures: - ar - ca - cs - da - de - el - en - es - et - eu - fi - fr - gl - he - hr - hu - is - it - ja - lt - lv - mk - nl - no - pl - pt-BR - pt-PT - ro - ru - sk - sv - tr - ua - vi - zh-CN - zh-TW sf_sfSelect2Widgets_select2_web_dir: /sfSelect2WidgetsPlugin/select2 sf_sfSelect2Widgets_width: resolve sf_standard_helpers: - Partial - Cache sf_symfony_lib_dir: /Developers/symfony/lib sf_template_cache_dir: /Developers/hosting/helpshop.by/cache/frontend/dev/template sf_test_cache_dir: /Developers/hosting/helpshop.by/cache/frontend/dev/test sf_test_dir: /Developers/hosting/helpshop.by/test sf_upload_dir: /Developers/hosting/helpshop.by/web/uploads sf_upload_dir_name: uploads sf_use_database: true sf_web_debug: true sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /Developers/hosting/helpshop.by/web symfony.asset.stylesheets_included: true
cookie: { }
env: { }
files: { }
get:
bld: '23'
type: is_sale
post: { }
server:
CONTEXT_DOCUMENT_ROOT: /Developers/hosting/helpshop.by/web
CONTEXT_PREFIX: ''
DOCUMENT_ROOT: /Developers/hosting/helpshop.by/web
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: '*/*'
HTTP_ACCEPT_ENCODING: 'gzip, br'
HTTP_CDN_LOOP: 'cloudflare; loops=1'
HTTP_CF_CONNECTING_IP: 3.137.210.249
HTTP_CF_IPCOUNTRY: US
HTTP_CF_RAY: 93813daf8db50cda-ORD
HTTP_CF_VISITOR: '{"scheme":"https"}'
HTTP_CONNECTION: Keep-Alive
HTTP_HOST: helpshop.by
HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
HTTP_X_FORWARDED_HOST: helpshop.by
HTTP_X_FORWARDED_PORT: '443'
HTTP_X_FORWARDED_PROTO: https
HTTP_X_FORWARDED_SERVER: helpshop.by
PATH: '/usr/bin:/bin:/usr/sbin:/sbin'
PATH_INFO: /realestate.html
PATH_TRANSLATED: 'redirect:/index.php'
PHP_SELF: /_dev.php/realestate.html
QUERY_STRING: 'bld=23&type=is_sale'
REMOTE_ADDR: 3.137.210.249
REMOTE_PORT: '54212'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1745955310
REQUEST_TIME_FLOAT: 1745955310.964
REQUEST_URI: '/_dev.php/realestate.html?bld=23&type=is_sale'
SCRIPT_FILENAME: /Developers/hosting/helpshop.by/web/_dev.php
SCRIPT_NAME: /_dev.php
SERVER_ADDR: 127.0.0.1
SERVER_ADMIN: admin@example.com
SERVER_NAME: helpshop.by
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: "<address>Apache Server at helpshop.by Port 443</address>\n"
SERVER_SOFTWARE: Apache
session: { }
php: 7.1.33 os: 'Darwin ns1.kedmans.com 17.7.0 Darwin Kernel Version 17.7.0: Fri Oct 30 13:34:27 PDT 2020; root:xnu-4570.71.82.8~1/RELEASE_X86_64 x86_64' extensions: 54: apache2handler 7: 'bcmath (7.1.33)' 8: 'bz2 (7.1.33)' 9: 'calendar (7.1.33)' 0: 'Core (7.1.33)' 10: 'ctype (7.1.33)' 11: 'curl (7.1.33)' 1: 'date (7.1.33)' 12: 'dba (7.1.33)' 13: 'dom (20031129)' 41: 'exif (7.1.33)' 15: 'fileinfo (1.0.5)' 16: 'filter (7.1.33)' 17: 'ftp (7.1.33)' 18: 'gd (7.1.33)' 55: 'gender (1.1.0)' 14: 'hash (1.0)' 20: 'iconv (7.1.33)' 56: 'imagick (3.7.0)' 57: 'intl (1.1.0)' 21: 'json (1.5.0)' 22: 'ldap (7.1.33)' 2: 'libxml (7.1.33)' 23: 'mbstring (7.1.33)' 35: 'mysqli (7.1.33)' 26: 'mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $)' 3: 'openssl (7.1.33)' 4: 'pcre (7.1.33)' 27: 'PDO (7.1.33)' 28: 'pdo_mysql (7.1.33)' 29: 'pdo_pgsql (7.1.33)' 30: 'pdo_sqlite (7.1.33)' 31: 'pgsql (7.1.33)' 32: 'Phar (2.0.2)' 33: 'posix (7.1.33)' 34: 'Reflection (7.1.33)' 24: 'session (7.1.33)' 36: 'shmop (7.1.33)' 37: 'SimpleXML (7.1.33)' 38: 'snmp (0.1)' 39: 'soap (7.1.33)' 40: 'sockets (7.1.33)' 19: 'SPL (7.1.33)' 5: 'sqlite3 (7.1.33)' 25: 'standard (7.1.33)' 42: 'sysvmsg (7.1.33)' 43: 'sysvsem (7.1.33)' 44: 'sysvshm (7.1.33)' 45: 'tidy (7.1.33)' 46: 'tokenizer (7.1.33)' 47: 'wddx (7.1.33)' 48: 'xml (7.1.33)' 49: 'xmlreader (7.1.33)' 50: 'xmlrpc (7.1.33)' 51: 'xmlwriter (7.1.33)' 52: 'xsl (7.1.33)' 53: 'zip (1.13.5)' 6: 'zlib (7.1.33)'
version: 1.5.20-dev path: /Developers/symfony/lib
Parameters:
$page (integer)$type (string)$mall (array)$title (string)$result (string)$pavilions (array)No parameters were passed to this template.
Parameters:
$pavilions (array)$result (string)No parameters were passed to this template.
Parameters:
$type (string)$malls (NULL)$mall (array)Parameters:
$mall (array)No parameters were passed to this template.
No parameters were passed to this template.
No parameters were passed to this template.
No parameters were passed to this template.
| # | type | message |
|---|---|---|
| 1 | sfPatternRouting | Match route "real_estate" (/realestate.html) for /realestate.html with parameters array ( 'module' => 'real_estate', 'action' => 'index',) |
| 2 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 3 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 4 | real_estateActions | Call "real_estateActions->executeIndex()" |
| 5 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 6 | Doctrine_Connection_Mysql | query : SELECT m.id, m.name FROM mall m WHERE id = 23; - () |
| 7 | Doctrine_Connection_Mysql | query : SELECT count(*) AS num_results FROM (SELECT p.id FROM pavilion p INNER JOIN pavilion_real_estate pre ON p.id = pre.id WHERE pre.mall_id = 23 AND pre.is_sale = 1) dctrn_count_query - () |
| 8 | Doctrine_Connection_Mysql | query : SELECT pre.id, p.floor, p.sector, p.line, p.number, p.hide_number, pre.paid as paid, pre.slug, pre.contacts as contacts, pre.mall_name as mall_name, pre.is_rent as is_rent, pre.is_sale as is_sale, pre.trade_name as trade_name, pre.trade_area as trade_area, pre.price_per_meter_rent FROM pavilion p INNER JOIN pavilion_real_estate pre ON p.id = pre.id WHERE pre.mall_id = 23 AND pre.is_sale = 1 GROUP BY p.id ORDER BY pre.rating DESC LIMIT 0,21; - () |
| 9 | sfPHPView | Render "sf_app_dir/modules/real_estate/templates/indexSuccess.php" |
| 10 | sfPartialView | Render "sf_app_dir/modules/block/templates/_flash.php" |
| 11 | sfPartialView | Render "sf_app_dir/modules/real_estate/templates/_pavilions.php" |
| 12 | sfPartialView | Render "sf_app_dir/modules/block/templates/_assistant.php" |
| 13 | sfPartialView | Render "sf_app_dir/modules/real_estate/templates/_filter.php" |
| 14 | sfPartialView | Render "sf_app_dir/modules/real_estate/templates/_mall_select.php" |
| 15 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 16 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 17 | main | Get slot "open_graph" |
| 18 | sfPartialView | Render "sf_app_dir/modules/block/templates/_header.php" |
| 19 | sfPartialView | Render "sf_app_dir/modules/block/templates/_header_menu.php" |
| 20 | sfPartialView | Render "sf_app_dir/modules/block/templates/_footer.php" |
| 21 | sfPartialView | Render "sf_app_dir/modules/block/templates/_footer_menu.php" |
| 22 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 23 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 12 | 106.54 | 61 |
| Factories | 1 | 14.64 | 8 |
| Action "real_estate/index" | 1 | 15.51 | 8 |
| Database (Doctrine) | 4 | 13.02 | 7 |
| View "Success" for "real_estate/index" | 1 | 14.50 | 8 |
| Partial "block/_flash" | 1 | 0.27 | 0 |
| Partial "real_estate/_pavilions" | 1 | 5.41 | 3 |
| Partial "block/_assistant" | 1 | 0.21 | 0 |
| Partial "real_estate/_filter" | 1 | 0.64 | 0 |
| Partial "real_estate/_mall_select" | 1 | 0.24 | 0 |
| Partial "block/_header" | 1 | 0.66 | 0 |
| Partial "block/_header_menu" | 1 | 0.35 | 0 |
| Partial "block/_footer" | 1 | 2.60 | 1 |
| Partial "block/_footer_menu" | 1 | 2.34 | 1 |
SET NAMES 'UTF8'
SELECT m.id, m.name FROM mall m WHERE id = 23;
SELECT count(*) AS num_results FROM (SELECT p.id FROM pavilion p INNER JOIN pavilion_real_estate pre ON p.id = pre.id WHERE pre.mall_id = 23 AND pre.is_sale = 1) dctrn_count_query
SELECT pre.id, p.floor, p.sector, p.line, p.number, p.hide_number, pre.paid as paid, pre.slug, pre.contacts as contacts, pre.mall_name as mall_name, pre.is_rent as is_rent, pre.is_sale as is_sale, pre.trade_name as trade_name, pre.trade_area as trade_area, pre.price_per_meter_rent FROM pavilion p INNER JOIN pavilion_real_estate pre ON p.id = pre.id WHERE pre.mall_id = 23 AND pre.is_sale = 1 GROUP BY p.id ORDER BY pre.rating DESC LIMIT 0,21;