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: categories
  module: catalog
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: 1745914648

mod_catalog_enabled: true
mod_catalog_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: {  }
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.19.28.64
  HTTP_CF_IPCOUNTRY: US
  HTTP_CF_RAY: 937d5cf4fb53058c-IAD
  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: /categories.html
  PATH_TRANSLATED: 'redirect:/index.php'
  PHP_SELF: /_dev.php/categories.html
  QUERY_STRING: ''
  REMOTE_ADDR: 3.19.28.64
  REMOTE_PORT: '56231'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1745914648
  REQUEST_TIME_FLOAT: 1745914648.338
  REQUEST_URI: /_dev.php/categories.html
  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:

• $categories (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.

No parameters were passed to this template.

Doctrine Version: 1.2.4

1. SET NAMES 'UTF8'

   0.00s, "doctrine" connection

2. SELECT pg.id, pg.category_id, pg.category_name, pg.name, pg.slug, (SELECT count(pp.id) FROM pavilion_products pp WHERE pg.id = pp.group_id) as count_pavilion FROM product_group pg where pg.category_id != '10' ORDER BY count_pavilion DESC;

   0.44s, "doctrine" connection