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: register
  module: common
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:
  front/jquery.min.js: {  }
  front/placeholder.js: {  }
  front/common.js: {  }
  front/jquery.fancybox.js: {  }
  front/bootstrap.js: {  }
  front/html5shiv.min.js: {  }
  front/respond.min.js: {  }
stylesheets:
  reset.css: {  }
  front/font-awesome.min.css: {  }
  front/jquery.fancybox.css: {  }
  front/bootstrap.css: {  }
  front/style.css: {  }
metas: {  }
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: null
  default_culture: bg
  use_flash: true
  logging: '1'
  timeout: 1800
attributeHolder:
  symfony/user/sfUser/attributes: { app_vars: { email: furniture@zarra.bg, facebook: 'https://facebook.com/zarramebeli', linkedin: '', youtube: 'https://www.youtube.com/channel/UCj_38_JjN_HxSiXzQ5fO8jw', pinterest: 'https://www.pinterest.com/marketingzarrad/', phone: '+359 879 990 701', cell_phone: '+359 879 990 703', register_text_bg: 'Регистрирайте се и станете част от семейството на Zarra Design, за да използвате най-новата ни услуга: „Вашият списък с вдъхновения“ – процесът по обзавеждането на Вашия апартамент-мечта никога не е бил по-лесен. ', newslleter_email: mebeli_zarra@avb.bg, register_text_en: '', privacy_policy_link_bg: '', privacy_policy_link_en: '' }, newsletter: true }
culture: bg
authenticated: false
credentials: {  }
lastRequest: 1685975739

app_category_image_size:
  width: 960
  height: 250
  width_look: 195
  height_look: 140
app_cookie_settings:
  name: ff_cookie
  days: 14
app_file_type:
  1: { bg: Снимки, en: Images, file_bg: Снимка, file_en: Image }
  2: { bg: Файлове, en: Files, file_bg: Файл, file_en: File }
  3: { bg: Видеа, en: Videos, file_bg: 'YouTube код', file_en: 'YouTube Embed code' }
  4: { bg: 'Тапицерски услуги', en: 'Тапицерски услуги', file_bg: Снимка, file_en: Image }
  14: { bg: Файлове, en: Files, file_bg: Файл, file_en: File }
app_front_news_record_per_page: 3
app_front_records_per_page: 12
app_image_sizes:
  1: { width: 1500, height: 500 }
  3: { single_image_width: 224, single_image_height: 224 }
  13: { single_image_width: 960, single_image_height: 250, width_thumb: 224, height_thumb: 224 }
app_look_sizes:
  width: 120
  height: 120
  single_image_width: 670
  single_image_height: 480
app_news_record_per_page: 10
app_noreplay_email: no-replay@zarrabg.com
app_pages:
  1: { bg: 'Начална страница', en: 'Home page', is_single: true, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: true, has_files: false, has_link: true, has_short_description: false, has_single_image: false, has_video: false }
  2: { bg: 'За нас', en: 'About us', is_single: false, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: false }
  14: { bg: 'Условия за ползване на сайта', en: 'Term and Conditions', is_single: false, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: false }
  11: { bg: Производство, en: Производство, is_single: false, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: false }
  12: { bg: Услуги, en: Услуги, is_single: false, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: false }
  3: { bg: 'Актуални предложения', en: 'Актуални предложения', is_single: false, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: true, has_short_description: false, has_single_image: true, has_video: false }
  4: { bg: Контакти, en: Contact, is_single: false, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: true, has_short_description: true, has_single_image: false, has_video: false }
  5: { bg: Видео, en: Video, is_single: true, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: true }
  6: { bg: 'Въпроси и отговори', en: FAQ, is_single: false, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: false }
  7: { bg: Монтаж, en: Монтаж, is_single: true, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: false }
  8: { bg: Доставка, en: Delivery, is_single: true, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: false }
  10: { bg: 'Текст в секция ''Абонирай се''', en: 'Subscribe text', is_single: true, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: false, has_video: false }
  13: { bg: Новини, en: News, is_single: false, is_on_homepage: false, has_gallery: false, has_file_gallery: false, has_children: false, has_images: false, has_slider: false, has_files: false, has_link: false, has_short_description: false, has_single_image: true, has_video: false }
app_product_sizes:
  width: 800
  height: 600
  width_thumb: 224
  height_thumb: 224
app_records_per_page: 20
app_roles:
  admin: Administrator
  user: User
app_salt: 'h&lL0Be@u7ifUlWorL6'
app_slider_image:
  width: 1600
  height: 580
app_stock:
  - null
  - 'По запитване'
  - 'В наличност'
  - Изчерпан
  - 'Очакваме доставка'
  - 'По поръчка'
app_supported_languages:
  bg: Bulgarian
mod_common_enabled: true
mod_common_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /home/zarrabg/private/app/cache/frontend
sf_app_cache_dir: /home/zarrabg/private/app/cache/frontend/dev
sf_app_config_dir: /home/zarrabg/private/app/apps/frontend/config
sf_app_dir: /home/zarrabg/private/app/apps/frontend
sf_app_i18n_dir: /home/zarrabg/private/app/apps/frontend/i18n
sf_app_lib_dir: /home/zarrabg/private/app/apps/frontend/lib
sf_app_module_dir: /home/zarrabg/private/app/apps/frontend/modules
sf_app_template_dir: /home/zarrabg/private/app/apps/frontend/templates
sf_apps_dir: /home/zarrabg/private/app/apps
sf_cache: false
sf_cache_dir: /home/zarrabg/private/app/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /home/zarrabg/private/app/cache/frontend/dev/config
sf_config_dir: /home/zarrabg/private/app/config
sf_csrf_secret: 'JSIDUSI&D*^yg6sd56sGH6'
sf_data_dir: /home/zarrabg/private/app/data
sf_debug: true
sf_default_culture: bg
sf_enabled_modules:
  - default
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: common
sf_error_reporting: 24575
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: /home/zarrabg/private/app/cache/frontend/dev/i18n
sf_lib_dir: /home/zarrabg/private/app/lib
sf_log_dir: /home/zarrabg/private/app/log
sf_logging_enabled: true
sf_login_action: login
sf_login_module: common
sf_module_cache_dir: /home/zarrabg/private/app/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: /home/zarrabg/private/app/plugins
sf_root_dir: /home/zarrabg/private/app
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
  - Partial
  - Cache
  - SmartLinks
  - BreadCrumb
  - Text
  - I18N
sf_symfony_lib_dir: /home/zarrabg/private/app/lib/vendor/symfony/lib
sf_template_cache_dir: /home/zarrabg/private/app/cache/frontend/dev/template
sf_test_cache_dir: /home/zarrabg/private/app/cache/frontend/dev/test
sf_test_dir: /home/zarrabg/private/app/test
sf_upload_dir: /home/zarrabg/private/app/web/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/zarrabg/private/app/web
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true

cookie: {  }
env:
  CONTEXT_DOCUMENT_ROOT: /home/zarrabg/www/www
  CONTEXT_PREFIX: ''
  DOCUMENT_ROOT: /home/zarrabg/www/www
  GATEWAY_INTERFACE: CGI/1.1
  HTTPS: on
  HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  HTTP_ACCEPT_ENCODING: 'br,gzip'
  HTTP_ACCEPT_LANGUAGE: 'en-US,en;q=0.5'
  HTTP_CONNECTION: Keep-Alive
  HTTP_HOST: zarra.bg
  HTTP_IF_MODIFIED_SINCE: 'Sat, 28 Jan 2023 08:03:24 GMT'
  HTTP_USER_AGENT: 'CCBot/2.0 (https://commoncrawl.org/faq/)'
  OMP_THREAD_LIMIT: '1'
  PATH: '/usr/local/bin:/usr/bin:/bin'
  QUERY_STRING: ''
  REDIRECT_STATUS: '200'
  REDIRECT_URL: /register
  REMOTE_ADDR: 35.172.111.47
  REMOTE_PORT: '53028'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_URI: /register
  SCRIPT_FILENAME: /home/zarrabg/www/www/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 195.8.222.33
  SERVER_ADMIN: admin@zarra.bg
  SERVER_NAME: zarra.bg
  SERVER_PORT: '443'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
  SSL_TLS_SNI: zarra.bg
  TZ: Europe/Sofia
  UNIQUE_ID: ZH3yu4lml2dCu5gOUcPFbQAABdY
files: {  }
get: {  }
post: {  }
server:
  CONTEXT_DOCUMENT_ROOT: /home/zarrabg/www/www
  CONTEXT_PREFIX: ''
  DOCUMENT_ROOT: /home/zarrabg/www/www
  GATEWAY_INTERFACE: CGI/1.1
  HTTPS: on
  HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  HTTP_ACCEPT_ENCODING: 'br,gzip'
  HTTP_ACCEPT_LANGUAGE: 'en-US,en;q=0.5'
  HTTP_CONNECTION: Keep-Alive
  HTTP_HOST: zarra.bg
  HTTP_IF_MODIFIED_SINCE: 'Sat, 28 Jan 2023 08:03:24 GMT'
  HTTP_USER_AGENT: 'CCBot/2.0 (https://commoncrawl.org/faq/)'
  OMP_THREAD_LIMIT: '1'
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PHP_SELF: /index.php
  QUERY_STRING: ''
  REDIRECT_STATUS: '200'
  REDIRECT_URL: /register
  REMOTE_ADDR: 35.172.111.47
  REMOTE_PORT: '53028'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1685975739
  REQUEST_URI: /register
  SCRIPT_FILENAME: /home/zarrabg/www/www/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 195.8.222.33
  SERVER_ADMIN: admin@zarra.bg
  SERVER_NAME: zarra.bg
  SERVER_PORT: '443'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
  SSL_TLS_SNI: zarra.bg
  TZ: Europe/Sofia
  UNIQUE_ID: ZH3yu4lml2dCu5gOUcPFbQAABdY
  argc: 0
  argv: {  }
session: {  }

php: 5.3.29
os: 'Linux s801.sureserver.com 5.15.91-sure #2 SMP Wed Feb 15 02:53:34 EST 2023 x86_64'
extensions:
  7: bcmath
  8: bz2
  9: calendar
  54: cgi-fcgi
  0: 'Core (5.3.29)'
  10: ctype
  11: curl
  1: 'date (5.3.29)'
  12: 'dom (20031129)'
  2: ereg
  43: 'exif (1.4 $Id$)'
  14: 'fileinfo (1.0.5-dev)'
  15: 'filter (0.11.0)'
  16: ftp
  17: gd
  18: gettext
  19: gmp
  13: 'hash (1.0)'
  21: iconv
  22: 'intl (1.1.0)'
  23: 'json (1.2.1)'
  24: ldap
  3: libxml
  25: mbstring
  26: mcrypt
  55: mhash
  27: 'mysql (1.0)'
  28: 'mysqli (0.1)'
  29: pcntl
  4: pcre
  31: 'PDO (1.0.4dev)'
  32: 'pdo_mysql (1.0.2)'
  33: 'pdo_sqlite (1.0.1)'
  38: 'Phar (2.0.1)'
  35: posix
  36: pspell
  37: 'Reflection ($Id: 4af6c4c676864b1c0bfa693845af0688645c37cf $)'
  30: session
  39: 'SimpleXML (0.1)'
  40: soap
  41: sockets
  20: 'SPL (0.2)'
  42: 'SQLite (2.0-dev)'
  5: 'sqlite3 (0.7-dev)'
  34: 'standard (5.3.29)'
  44: 'sureacct (0.1)'
  45: 'tidy (2.0)'
  46: 'tokenizer (0.1)'
  47: wddx
  48: xml
  49: 'xmlreader (0.1)'
  50: 'xmlrpc (0.51)'
  51: 'xmlwriter (0.1)'
  52: 'xsl (0.1)'
  53: 'zip (1.11.0)'
  6: 'zlib (1.1)'

version: 1.4.16
path: /home/zarrabg/private/app/lib/vendor/symfony/lib

Parameters:

• $agreement_title (string)
• $agreement_body (string)
• $form (SignupForm)
  • $form['name'] (sfWidgetFormInputText)
  • $form['password'] (sfWidgetFormInputPassword)
  • $form['confirm_password'] (sfWidgetFormInputPassword)
  • $form['email'] (sfWidgetFormInputText)
  • $form['city'] (sfWidgetFormInputText)
  • $form['phone'] (sfWidgetFormInputText)
  • $form['street'] (sfWidgetFormInputText)
  • $form['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $is_root_category (NULL)
• $is_subcategory (NULL)
• $is_product (NULL)
• $slug (NULL)
• $type (NULL)
• $pages (array)

Parameters:

• $categories (Doctrine_Collection)

Parameters:

• $categories (Doctrine_Collection)
• $contacts (Doctrine_Collection)
• $page (Page)

Parameters:

• $records (Page)
• $is_show_newsletter (integer)
• $form (NewsletterForm)
  • $form['id'] (sfWidgetFormInputHidden)
  • $form['name'] (sfWidgetFormInputText)
  • $form['email'] (sfWidgetFormInputText)
  • $form['_csrf_token'] (sfWidgetFormInputHidden)

Doctrine Version: 1.2.4

1. SET NAMES 'UTF8'

   0.00s, "doctrine" connection

2. SELECT a.id AS a__id, a.var_key AS a__var_key, a.var_value AS a__var_value FROM app_var a

   0.00s, "doctrine" connection

3. SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.image_id AS p__image_id, p.file_id AS p__file_id, p.picture AS p__picture, p.on_homepage AS p__on_homepage, p.type AS p__type, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at FROM page p WHERE (p.type = '') LIMIT 1

   0.00s, "doctrine" connection

4. SELECT a.id AS a__id, a.var_key AS a__var_key, a.var_value AS a__var_value FROM app_var a WHERE (a.var_key = 'privacy_policy_link_bg')

   0.00s, "doctrine" connection

5. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND (c.parent_id IS NULL OR c.parent_id = 0) AND c2.is_published = '1') ORDER BY c.position

   0.00s, "doctrine" connection

6. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND c.parent_id = '2') ORDER BY c.position

   0.00s, "doctrine" connection

7. SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '2')

   0.00s, "doctrine" connection

8. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND c.parent_id = '1') ORDER BY c.position

   0.00s, "doctrine" connection

9. SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '1')

   0.00s, "doctrine" connection

10. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND c.parent_id = '3') ORDER BY c.position

    0.00s, "doctrine" connection

11. SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '3')

    0.00s, "doctrine" connection

12. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND c.parent_id = '4') ORDER BY c.position

    0.00s, "doctrine" connection

13. SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '4')

    0.00s, "doctrine" connection

14. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND c.parent_id = '5') ORDER BY c.position

    0.00s, "doctrine" connection

15. SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '5')

    0.00s, "doctrine" connection

16. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND c.parent_id = '6') ORDER BY c.position

    0.00s, "doctrine" connection

17. SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '6')

    0.00s, "doctrine" connection

18. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND c.parent_id = '7') ORDER BY c.position

    0.00s, "doctrine" connection

19. SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '7')

    0.00s, "doctrine" connection

20. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND c.parent_id = '8') ORDER BY c.position

    0.00s, "doctrine" connection

21. SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '8')

    0.00s, "doctrine" connection

22. SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'bg' AND (c.parent_id IS NULL OR c.parent_id = 0) AND c2.is_published = '1') ORDER BY c.position

    0.00s, "doctrine" connection

23. SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.image_id AS p__image_id, p.file_id AS p__file_id, p.picture AS p__picture, p.on_homepage AS p__on_homepage, p.type AS p__type, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.slug AS p2__slug, p2.short_title AS p2__short_title, p2.link AS p2__link, p2.file AS p2__file, p2.body AS p2__body, p2.short_body AS p2__short_body, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.is_published AS p2__is_published, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.type = '4' AND p2.lang = 'bg' AND p2.is_published = '1') ORDER BY p.position

    0.00s, "doctrine" connection

24. SELECT DISTINCT p3.id FROM page p3 LEFT JOIN page_translation p4 ON p3.id = p4.id WHERE p3.type = '1' AND p4.lang = 'bg' AND p4.is_published = '1' ORDER BY p3.position LIMIT 1

    0.00s, "doctrine" connection

25. SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.image_id AS p__image_id, p.file_id AS p__file_id, p.picture AS p__picture, p.on_homepage AS p__on_homepage, p.type AS p__type, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.slug AS p2__slug, p2.short_title AS p2__short_title, p2.link AS p2__link, p2.file AS p2__file, p2.body AS p2__body, p2.short_body AS p2__short_body, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.is_published AS p2__is_published, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE p.id IN ('1') AND (p.type = '1' AND p2.lang = 'bg' AND p2.is_published = '1') ORDER BY p.position

    0.00s, "doctrine" connection

26. SELECT DISTINCT p3.id FROM page p3 LEFT JOIN page_translation p4 ON p3.id = p4.id WHERE p3.type = '10' AND p4.lang = 'bg' AND p4.is_published = '1' ORDER BY p3.position LIMIT 1

    0.00s, "doctrine" connection

27. SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.image_id AS p__image_id, p.file_id AS p__file_id, p.picture AS p__picture, p.on_homepage AS p__on_homepage, p.type AS p__type, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.slug AS p2__slug, p2.short_title AS p2__short_title, p2.link AS p2__link, p2.file AS p2__file, p2.body AS p2__body, p2.short_body AS p2__short_body, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.is_published AS p2__is_published, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE p.id IN ('20') AND (p.type = '10' AND p2.lang = 'bg' AND p2.is_published = '1') ORDER BY p.position

    0.00s, "doctrine" connection