options:
  path_info_key: PATH_INFO
  path_info_array: SERVER
  http_port: null
  https_port: null
  default_format: null
  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: show
  guid: c7868ddf-c9e0-55a6-9ad3-bb
  module: category
  text: zaklady_opiekunczo_lecznicze
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:
  jquery-1.4.4.js: {  }
  jquery.autocomplete.min.js: {  }
  jquery.form-defaults.js: {  }
  jquery.autocomplete.css: {  }
  msgbox/jquery.msgbox.min.js: {  }
  signin.js: {  }
  whcookies.js: {  }
  w.js: {  }
stylesheets:
  style.css: {  }
  style-mapa.css: {  }
  jquery.autocomplete.css: {  }
  msgbox/jquery.msgbox.css: {  }
  default: {  }
  style_wyniki_wyszukiwania.css: {  }
metas:
  keywords: medindex
  language: pl
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: null
  default_culture: pl
  use_flash: true
  logging: '1'
  timeout: 1800
attributeHolder:
  symfony/user/sfUser/attributes: { last_category: c7868ddf-c9e0-55a6-9ad3-bb, search_filters: { province: mazowieckie, category: 'Zakłady opiekuńczo-lecznicze' } }
culture: pl

app_allowedaddresses: 213.216.91.107;87.204.221.82;87.204.221.83;87.204.221.84;62.233.247.193;62.233.247.194;62.233.247.195;62.233.247.196;194.150.206.2;79.173.57.86;194.187.75.132;88.151.140.90;88.151.140.91;88.151.140.92;88.151.140.93;88.151.140.94;88.151.140.234;88.151.140.235;88.151.140.236;88.151.140.237;88.151.140.238;91.232.45.96
app_city_list: 'Warszawa,Kraków,Poznań,Gdańsk,Gdynia,Sopot,Toruń,Częstochowa,Kielce,Rzeszów,Olsztyn,Kalisz'
app_concierge_ip: 213.216.91.107
app_country_clients: Poland
app_country_version: poland
app_default_domain: medindex.pl
app_enabled_modules:
  - default
  - sfEasyGMapPlugin
  - sfGuardAuth
  - sfCaptchaGD
app_google_maps_api_keys:
  default: ABQIAAAAXAJG-6tTPBcZsPleg_zHFxRgdr9tc6AIpP8hJtF_707clg4cVxQSrWkGx4qewMz5ugxZRu5nOqRx9Q
  localhost: ABQIAAAA0lL-YZRVQqAUZAia92M07RT2yXp_ZAY8_ufC3CFXhHIE1NvwkxTloqNt9NF2svdffUPSFsFyiVv46Q
  81.210.3.118: ABQIAAAA0lL-YZRVQqAUZAia92M07RSmEnNk3xGt00pU91wsVOUfo0sHKxQla2hamJnVCStL8sUHPPgkgWV-Mg
  10.30.0.100: ABQIAAAA0lL-YZRVQqAUZAia92M07RROBfD9hrKJWZ42t_4ftRjwcOkkbxRYjpJxoMEmJFBBXB_cUTvUhtaf6Q
  erfp.pl: ABQIAAAANi9We6LlwmU3uVDF1zQ9ExRnxAordRW_br0Z4OoLvRQrZT4KmBSz2BqYQHPwizh7PVexOI4sj_1Onw
  www.erfp.pl: ABQIAAAANi9We6LlwmU3uVDF1zQ9ExTXN0NClc2bTUEaOJwhJ8WW8t9WKhQFKtbz6c6nTS0KQDqNd_9auxmyIQ
  ixec.eu: ABQIAAAANi9We6LlwmU3uVDF1zQ9ExRLyH4nbTXuMmim11WBVex2J7OKYxRlaTTvu5yWSrMCLYwtw7P1RRf93A
  www.ixec.eu: ABQIAAAANi9We6LlwmU3uVDF1zQ9ExR9AwgNp8zGtNnz3cvq5Qa70j4chxSZOhTX1N-wWicQf9hGG6k4uIi7yA
  crm.wgcc.pl: ABQIAAAA0lL-YZRVQqAUZAia92M07RQzhYytYaEpeG-dxFxbQ7f_z4fDehQ_Ungrs6GW727xcKgJ91Ee7dpIpw
  medindex.pl: ABQIAAAA0lL-YZRVQqAUZAia92M07RQNwSY7OR_b82eSP4L1k0HhO7iztxQGrbyHWop5FKcrU_vXGMLtULDYPA
  www.medindex.pl: ABQIAAAA0lL-YZRVQqAUZAia92M07RSqQX3RsPrLfc5HYCC9Q9vAS-DepxTpL6r806hnY3bF46hEcIGWpWfCVg
app_i18n: true
app_ip_with_nonplatinum_access: 213.216.91.107;62.233.247.193;62.233.247.194;62.233.247.195;194.150.206.2;79.173.57.86;88.151.140.90;88.151.140.91;88.151.140.92;88.151.140.93;88.151.140.94;88.151.140.234;88.151.140.235;88.151.140.236;88.151.140.237;88.151.140.238;91.232.45.96
app_login_action: signin
app_login_module: sfGuardAuth
app_max_positions_on_page: 15
app_provinces_list: 'dolnośląskie,kujawsko-pomorskie,łódzkie,lubelskie,lubuskie,małopolskie,mazowieckie,opolskie,podkarpackie,podlaskie,pomorskie,śląskie,świętokrzyskie,warmińsko-mazurskie,wielkopolskie,zachodniopomorskie'
app_sfImageTransformPlugin_default_adapter: GD
app_sfImageTransformPlugin_default_image:
  mime_type: image/png
  filename: Untitled.png
  width: 100
  height: 100
  color: '#FFFFFF'
app_sfImageTransformPlugin_font_dir: /usr/share/fonts/truetype/msttcorefonts
app_sfImageTransformPlugin_mime_type:
  auto_detect: false
  library: gd_mime_type
app_sf_guard_plugin_success_signin_url: '@admin'
app_sf_guard_plugin_success_signout_url: '@homepage'
app_standard_helpers:
  - Partial
  - Cache
  - I18N
app_tm_ip: 213.216.91.107;62.233.247.195;62.233.247.193;62.233.247.194;46.105.15.50;194.150.206.2;79.173.57.86;88.151.140.90;88.151.140.91;88.151.140.92;88.151.140.93;88.151.140.94;88.151.140.234;88.151.140.235;88.151.140.236;88.151.140.237;88.151.140.238;91.232.45.96
mod_category_enabled: true
mod_category_view_class: sfPHP
mod_default_enabled: true
mod_default_view_class: sfPHP
mod_search_enabled: true
mod_search_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: //cache/frontend
sf_app_cache_dir: //cache/frontend/dev
sf_app_config_dir: //apps/frontend/config
sf_app_dir: //apps/frontend
sf_app_i18n_dir: //apps/frontend/i18n
sf_app_lib_dir: //apps/frontend/lib
sf_app_module_dir: //apps/frontend/modules
sf_app_template_dir: //apps/frontend/templates
sf_apps_dir: //apps
sf_cache: false
sf_cache_dir: //cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: //cache/frontend/dev/config
sf_config_dir: //config
sf_csrf_secret: UniqueSecret
sf_culture: pl
sf_data_dir: //data
sf_debug: false
sf_default_culture: pl
sf_enabled_modules:
  - default
  - sfGuardAuth
  - sfCaptchaGD
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 8191
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: //cache/frontend/dev/i18n
sf_lib_dir: //lib
sf_log_dir: //log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: sfGuardAuth
sf_module_cache_dir: //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: //plugins
sf_root_dir: /
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
sf_symfony_lib_dir: /sf/vendor/symfony-1.4.8/lib
sf_template_cache_dir: //cache/frontend/dev/template
sf_test_cache_dir: //cache/frontend/dev/test
sf_test_dir: //test
sf_upload_dir: //web/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: //web
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true

cookie:
  symfony: 240314a61a7ff2ed1b8e857b5e5d6edd
env:
  CURL_HOME: /
  DOCUMENT_ROOT: /
  GATEWAY_INTERFACE: CGI/1.1
  GATEWAY_ULTRACGI: 018145596e7f8fcf9f46d378c2c97359
  HTTP_ACCEPT: '*/*'
  HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
  HTTP_CONNECTION: close
  HTTP_COOKIE: symfony=240314a61a7ff2ed1b8e857b5e5d6edd
  HTTP_HOST: medindex.pl
  HTTP_REFERER: 'http://medindex.pl/frontend_dev.php/filtr/filterProvinceSet/mazowieckie.html'
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  HTTP_X_FORWARDED_FOR: 18.221.21.242
  HTTP_X_HOMESERVER_PORT_STR: plain
  HTTP_X_REAL_IP: 18.221.21.242
  PATH: '/usr/local/pssql55/bin:/usr/local/pgsql9/bin:/bin:/usr/bin:/usr/local/bin'
  PATH_INFO: /category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  PATH_REDIRECTED: /frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  PATH_TRANSLATED: /category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  QUERY_STRING: ''
  REDIRECT_STATUS: '200'
  REDIRECT_URL: /frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  REMOTE_ADDR: 18.221.21.242
  REMOTE_HOST: ec2-18-221-21-242.us-east-2.compute.amazonaws.com
  REMOTE_PORT: '60160'
  REQUEST_METHOD: GET
  REQUEST_URI: /frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  SCRIPT_FILENAME: /web/frontend_dev.php
  SCRIPT_NAME: /web/frontend_dev.php
  SCRIPT_URI: 'http://medindex.pl/frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html'
  SCRIPT_URL: /frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  SERVER_ADDR: 212.85.124.29
  SERVER_ADMIN: 4kprojekt@4kprojekt.home.pl
  SERVER_ID: 4kprojekt
  SERVER_NAME: medindex.pl
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SOFTWARE: 'IdeaWebServer/6.3.1 (like Apache)'
  SM_HOSTNAME: medindex.pl
  TMP: /tmp
  TMPDIR: /tmp
  TZ: ':/etc/localtime'
files: {  }
get: {  }
post: {  }
server:
  CURL_HOME: /
  DOCUMENT_ROOT: /
  GATEWAY_INTERFACE: CGI/1.1
  GATEWAY_ULTRACGI: 018145596e7f8fcf9f46d378c2c97359
  HTTP_ACCEPT: '*/*'
  HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
  HTTP_CONNECTION: close
  HTTP_COOKIE: symfony=240314a61a7ff2ed1b8e857b5e5d6edd
  HTTP_HOST: medindex.pl
  HTTP_REFERER: 'http://medindex.pl/frontend_dev.php/filtr/filterProvinceSet/mazowieckie.html'
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  HTTP_X_FORWARDED_FOR: 18.221.21.242
  HTTP_X_HOMESERVER_PORT_STR: plain
  HTTP_X_REAL_IP: 18.221.21.242
  PATH: '/usr/local/pssql55/bin:/usr/local/pgsql9/bin:/bin:/usr/bin:/usr/local/bin'
  PATH_INFO: /category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  PATH_REDIRECTED: /frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  PATH_TRANSLATED: /category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  PHP_SELF: /web/frontend_dev.php
  QUERY_STRING: ''
  REDIRECT_STATUS: '200'
  REDIRECT_URL: /frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  REMOTE_ADDR: 18.221.21.242
  REMOTE_HOST: ec2-18-221-21-242.us-east-2.compute.amazonaws.com
  REMOTE_PORT: '60160'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1745828795
  REQUEST_URI: /frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  SCRIPT_FILENAME: /web/frontend_dev.php
  SCRIPT_NAME: /frontend_dev.php
  SCRIPT_URI: 'http://medindex.pl/frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html'
  SCRIPT_URL: /frontend_dev.php/category/c7868ddf-c9e0-55a6-9ad3-bb/zaklady_opiekunczo_lecznicze.html
  SERVER_ADDR: 212.85.124.29
  SERVER_ADMIN: 4kprojekt@4kprojekt.home.pl
  SERVER_ID: 4kprojekt
  SERVER_NAME: medindex.pl
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SOFTWARE: 'IdeaWebServer/6.3.1 (like Apache)'
  SM_HOSTNAME: medindex.pl
  TMP: /tmp
  TMPDIR: /tmp
  TZ: ':/etc/localtime'
  argc: 0
  argv: {  }
session:
  symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { search_filters: { province: mazowieckie, category: 'Zakłady opiekuńczo-lecznicze' }, last_category: c7868ddf-c9e0-55a6-9ad3-bb } }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: pl
  symfony/user/sfUser/lastRequest: 1745828795

php: 5.2.17
os: 'Linux v028.home.net.pl 6.8.2 husak_dirty_pages_fix #1 SMP PREEMPT_DYNAMIC Tue Apr  2 22:06:51 CEST 2024 x86_64'
extensions:
  5: bcmath
  6: bz2
  7: calendar
  8: ctype
  9: curl
  0: 'date (5.2.17)'
  10: dba
  11: dbase
  12: 'dom (20031129)'
  51: 'exif (1.4 $Id$)'
  14: 'fileinfo (0.1)'
  15: 'filter (0.11.0)'
  16: ftp
  17: gd
  18: 'geoip (1.0.8)'
  19: gettext
  20: gmp
  13: 'hash (1.0)'
  22: iconv
  65: 'IdeaMod (1.0)'
  44: imap
  67: 'ionCube Loader (10.3.9)'
  24: 'json (1.2.1)'
  25: ldap
  1: libxml
  26: 'mailparse (2.1.6)'
  27: mbstring
  28: mcrypt
  29: mhash
  30: ming
  31: mssql
  32: 'mysql (1.0)'
  46: 'mysqli (0.1)'
  2: openssl
  3: pcre
  66: 'PDFlib (3.0.4)'
  35: 'PDO (1.0.4dev)'
  36: 'pdo_dblib (1.0.1)'
  37: 'pdo_mysql (1.0.2)'
  38: 'pdo_pgsql (1.0.2)'
  39: 'pdo_sqlite (1.0.1)'
  40: pgsql
  41: posix
  42: pspell
  43: 'Reflection (0.1)'
  21: session
  45: shmop
  33: 'SimpleXML (0.1)'
  47: soap
  48: sockets
  34: 'SPL (0.2)'
  49: 'SQLite (2.0-dev)'
  50: 'ssh2 (0.13)'
  23: 'standard (5.2.17)'
  52: sysvmsg
  53: sysvsem
  54: sysvshm
  55: 'tidy (2.0)'
  56: 'tokenizer (0.1)'
  57: 'translit (0.6.2)'
  58: wddx
  59: xml
  60: 'xmlreader (0.1)'
  61: 'xmlrpc (0.51)'
  62: 'xmlwriter (0.1)'
  63: 'xsl (0.1)'
  68: 'Zend OPcache (7.0.5FE)'
  64: 'zip (1.8.11)'
  4: 'zlib (1.1)'

version: 1.4.8
path: /sf/vendor/symfony-1.4.8/lib

Parameters:

• $title (string)
• $pager (sfDoctrinePager)
• $gmap (NULL)
• $guid (string)

Parameters:

• $search_filters (array)

Parameters:

• $login (boolean)
• $form (sfGuardFormSignin)
  • $form['username'] (sfWidgetFormInputText)
  • $form['password'] (sfWidgetFormInputPassword)
  • $form['remember'] (sfWidgetFormInputCheckbox)
  • $form['_csrf_token'] (sfWidgetFormInputHidden)
• $user (myUser)
• $isSuperEditor (boolean)
• $isConcierge (boolean)

Doctrine Version: 1.2.3

1. SET NAMES 'UTF8'

   0.00s, "doctrine" connection

2. INSERT INTO visitor (ip, created_at, updated_at) VALUES ('18.221.21.242', '2025-04-28 10:26:35', '2025-04-28 10:26:35')

   0.00s, "doctrine" connection

3. SELECT COUNT(*) AS num_results FROM visitor v WHERE v.created_at BETWEEN '2025-04-28 09:26:35' AND '2025-04-28 10:26:35' AND v.ip = '18.221.21.242'

   0.00s, "doctrine" connection

4. SELECT c.id AS c__id, c.guid AS c__guid, c.category_id AS c__category_id, c.displayonmainpage AS c__displayonmainpage, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = 'pl') WHERE (c.guid like 'c7868ddf-c9e0-55a6-9ad3-bb')

   0.00s, "doctrine" connection

5. SELECT c.id AS c__id, c.guid AS c__guid, c.category_id AS c__category_id, c.displayonmainpage AS c__displayonmainpage, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM category c WHERE (c.category_id IN ('596'))

   0.00s, "doctrine" connection

6. SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM client c INNER JOIN client_category c2 ON c.id = c2.client_id INNER JOIN category c3 ON c2.category_id = c3.id INNER JOIN category_translation c4 ON c3.id = c4.id AND (c4.lang = 'pl') LEFT JOIN province p ON c.province_id = p.id WHERE c.expiration_date > NOW() AND p.name like 'mazowieckie' AND c4.name like 'Zakłady opiekuńczo-lecznicze' GROUP BY c.id) dctrn_count_query

   0.02s, "doctrine" connection

7. SELECT c.id AS c__id, c.name AS c__name, c.logo AS c__logo, c.nip AS c__nip, c.telephone AS c__telephone, c.fax AS c__fax, c.mail AS c__mail, c.www AS c__www, c.city AS c__city, c.post_code AS c__post_code, c.street AS c__street, c.geo_x AS c__geo_x, c.geo_y AS c__geo_y, c.packet_id AS c__packet_id, c.province_id AS c__province_id, c.user_id AS c__user_id, c.guid AS c__guid, c.active AS c__active, c.offer AS c__offer, c.rebate AS c__rebate, c.rebate_img AS c__rebate_img, c.old_token AS c__old_token, c.domain AS c__domain, c.old_adm_guid AS c__old_adm_guid, c.old_id AS c__old_id, c.expiration_date AS c__expiration_date, c.contact_request AS c__contact_request, c.key_words_tmp AS c__key_words_tmp, c.categories_tmp AS c__categories_tmp, c.enhanced_count AS c__enhanced_count, c.have_discount AS c__have_discount, c.have_tabs AS c__have_tabs, c.status_id AS c__status_id, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.client_id AS c2__client_id, c2.category_id AS c2__category_id, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at, c3.id AS c3__id, c3.guid AS c3__guid, c3.category_id AS c3__category_id, c3.displayonmainpage AS c3__displayonmainpage, c3.created_at AS c3__created_at, c3.updated_at AS c3__updated_at, c4.id AS c4__id, c4.name AS c4__name, c4.lang AS c4__lang FROM client c INNER JOIN client_category c2 ON c.id = c2.client_id INNER JOIN category c3 ON c2.category_id = c3.id INNER JOIN category_translation c4 ON c3.id = c4.id AND (c4.lang = 'pl') LEFT JOIN province p ON c.province_id = p.id WHERE (c.expiration_date > NOW() AND p.name like 'mazowieckie' AND c4.name like 'Zakłady opiekuńczo-lecznicze') ORDER BY c.active desc, c.name asc

   0.02s, "doctrine" connection

8. SELECT c.id AS c__id, c.name AS c__name, c.logo AS c__logo, c.nip AS c__nip, c.telephone AS c__telephone, c.fax AS c__fax, c.mail AS c__mail, c.www AS c__www, c.city AS c__city, c.post_code AS c__post_code, c.street AS c__street, c.geo_x AS c__geo_x, c.geo_y AS c__geo_y, c.packet_id AS c__packet_id, c.province_id AS c__province_id, c.user_id AS c__user_id, c.guid AS c__guid, c.active AS c__active, c.offer AS c__offer, c.rebate AS c__rebate, c.rebate_img AS c__rebate_img, c.old_token AS c__old_token, c.domain AS c__domain, c.old_adm_guid AS c__old_adm_guid, c.old_id AS c__old_id, c.expiration_date AS c__expiration_date, c.contact_request AS c__contact_request, c.key_words_tmp AS c__key_words_tmp, c.categories_tmp AS c__categories_tmp, c.enhanced_count AS c__enhanced_count, c.have_discount AS c__have_discount, c.have_tabs AS c__have_tabs, c.status_id AS c__status_id, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.client_id AS c2__client_id, c2.category_id AS c2__category_id, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at, c3.id AS c3__id, c3.guid AS c3__guid, c3.category_id AS c3__category_id, c3.displayonmainpage AS c3__displayonmainpage, c3.created_at AS c3__created_at, c3.updated_at AS c3__updated_at, c4.id AS c4__id, c4.name AS c4__name, c4.lang AS c4__lang FROM client c INNER JOIN client_category c2 ON c.id = c2.client_id INNER JOIN category c3 ON c2.category_id = c3.id INNER JOIN category_translation c4 ON c3.id = c4.id AND (c4.lang = 'pl') LEFT JOIN province p ON c.province_id = p.id WHERE (c.expiration_date > NOW() AND p.name like 'mazowieckie' AND c4.name like 'Zakłady opiekuńczo-lecznicze') ORDER BY c.active desc, c.name asc

   0.02s, "doctrine" connection