config
view
logs
4096.0 KB
146 ms
5
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: m33f1n5
plan: m33f1
slug: tc-riga
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: 'ТЦ «Рига» - пав. 5 - схема 1 этажа'
description: 'Схемы торговых павильонов ТЦ «Рига». Схема 1 этажа'
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: 1745977748
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: { }
env: { }
files: { }
get:
pav: m33f1n5
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.17.159.53
HTTP_CF_IPCOUNTRY: US
HTTP_CF_RAY: 938361797898dadc-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: /bld/tc-riga/m33f1.html
PATH_TRANSLATED: 'redirect:/index.php/tc-riga/m33f1.html'
PHP_SELF: /_dev.php/bld/tc-riga/m33f1.html
QUERY_STRING: pav=m33f1n5
REMOTE_ADDR: 3.17.159.53
REMOTE_PORT: '51381'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1745977748
REQUEST_TIME_FLOAT: 1745977748.036
REQUEST_URI: '/_dev.php/bld/tc-riga/m33f1.html?pav=m33f1n5'
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:
$mall (array)$plan (array)$pavilions (array)$pav (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.
| # | type | message |
|---|---|---|
| 1 | sfPatternRouting | Match route "mall_plan" (/bld/:slug/:plan.html) for /bld/tc-riga/m33f1.html with parameters array ( 'module' => 'mall', 'action' => 'plan', 'slug' => 'tc-riga', 'plan' => 'm33f1',) |
| 2 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 3 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 4 | mallActions | Call "mallActions->executePlan()" |
| 5 | mallActions | Change layout to "layout_plan" |
| 6 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 7 | Doctrine_Connection_Mysql | query : 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-riga'; - () |
| 8 | Doctrine_Connection_Mysql | query : SELECT * FROM mall_plan m WHERE m.slug = 'm33f1'; - () |
| 9 | Doctrine_Connection_Mysql | query : SELECT * FROM pavilion p WHERE p.mall_id = 33 AND p.floor = 1; - () |
| 10 | Doctrine_Connection_Mysql | query : SELECT mp.floor, mp.slug FROM mall_plan mp WHERE mp.mall_id = 33 ORDER BY mp.floor DESC; - () |
| 11 | sfPHPView | Render "sf_app_dir/modules/mall/templates/planSuccess.php" |
| 12 | sfPartialView | Render "sf_app_dir/modules/mall/templates/_header_plan.php" |
| 13 | sfPHPView | Decorate content with "sf_app_dir/templates/layout_plan.php" |
| 14 | sfPHPView | Render "sf_app_dir/templates/layout_plan.php" |
| 15 | main | Get slot "open_graph" |
| 16 | sfPartialView | Render "sf_app_dir/modules/block/templates/_header.php" |
| 17 | sfPartialView | Render "sf_app_dir/modules/block/templates/_header_menu.php" |
| 18 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 19 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 13 | 78.23 | 53 |
| Factories | 1 | 12.22 | 8 |
| Action "mall/plan" | 1 | 15.20 | 10 |
| Database (Doctrine) | 5 | 12.93 | 8 |
| View "Success" for "mall/plan" | 1 | 17.24 | 11 |
| Partial "mall/_header_plan" | 1 | 0.49 | 0 |
| Partial "block/_header" | 1 | 0.61 | 0 |
| Partial "block/_header_menu" | 1 | 0.31 | 0 |
SET NAMES 'UTF8'
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-riga';
SELECT * FROM mall_plan m WHERE m.slug = 'm33f1';
SELECT * FROM pavilion p WHERE p.mall_id = 33 AND p.floor = 1;
SELECT mp.floor, mp.slug FROM mall_plan mp WHERE mp.mall_id = 33 ORDER BY mp.floor DESC;