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: plan
  module: mall
  pav: m23f2scn46
  plan: m23f2
  slug: tc-zerkalo
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: 'ТЦ «Зеркало» -  ESTILO (пав. 46) - схема 2 этажа - Сектор В'
  description: 'Схемы торговых павильонов ТЦ «Зеркало». Схема 2 этажа'
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: 1745963996

mod_mall_enabled: true
mod_mall_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.view.mall_plan_layout: layout_plan

cookie:
  symfony: bd5854vre7j5pel09qi5v9q12v
env: {  }
files: {  }
get:
  pav: m23f2scn46
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: 13.59.210.36
  HTTP_CF_IPCOUNTRY: US
  HTTP_CF_RAY: 938211be4b9ee544-ORD
  HTTP_CF_VISITOR: '{"scheme":"https"}'
  HTTP_CONNECTION: Keep-Alive
  HTTP_COOKIE: symfony=bd5854vre7j5pel09qi5v9q12v
  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: /bld/tc-zerkalo/m23f2.html
  PATH_TRANSLATED: 'redirect:/index.php/tc-zerkalo/m23f2.html'
  PHP_SELF: /_dev.php/bld/tc-zerkalo/m23f2.html
  QUERY_STRING: pav=m23f2scn46
  REMOTE_ADDR: 13.59.210.36
  REMOTE_PORT: '61294'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1745963995
  REQUEST_TIME_FLOAT: 1745963995.95
  REQUEST_URI: '/_dev.php/bld/tc-zerkalo/m23f2.html?pav=m23f2scn46'
  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:
  symfony/user/sfUser/attributes: {  }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1745963995

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:

• $mall (array)
• $plan (array)
• $pavilions (array)
• $pav (string)
• $sector (string)
• $plans (array)

Parameters:

• $mall (array)
• $plans (array)
• $action (string)
• $floor (string)
• $pav (string)

No parameters were passed to this template.

No parameters were passed to this template.

Doctrine Version: 1.2.4

1. SET NAMES 'UTF8'

   0.00s, "doctrine" connection

2. SELECT m.id, m.photo, m.name, m.description, m.body, m.address, m.slug, m.is_closed, m.count_pavilions, m.count_available_pavilions, m.count_plans, m.geolocation_latitude, m.geolocation_longitude, m.geolocation_description, m.extensions, m.work, m.contact FROM mall m WHERE m.slug = 'tc-zerkalo';

   0.00s, "doctrine" connection

3. SELECT * FROM mall_plan m WHERE m.slug = 'm23f2';

   0.00s, "doctrine" connection

4. SELECT * FROM pavilion p WHERE p.mall_id = 23 AND p.floor = 2;

   0.01s, "doctrine" connection

5. SELECT mp.floor, mp.slug FROM mall_plan mp WHERE mp.mall_id = 23 ORDER BY mp.floor DESC;

   0.00s, "doctrine" connection