Zarra Център, 4000 Пловдив, бул. Кн. Мария Луиза 25А
Последвайте ни
Нови предложения, горещи промоции, игри, награди и полезни съвети за обзавеждането на дома Ви от български и чуждестранни дизайнери - всичко това можете да очаквате в новия ежемесечен бюлетин на Zarra Design. Споделете с нас Вашето име и email и позволете на вдъхновението да достигне до Вас!

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: category
category: '1'
category_slug: garderobi
module: products
root_category_slug: spalnq
attributeHolder:
sf_route: 'sfRoute Object()'

status:
code: 200
text: OK
options:
http_protocol: HTTP/2.0
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:
keywords: 'Гардероби, Зара Дизайн, гардеробни стаи, дрешници Пловдив,'
description: 'Повече удобство и простор във Вашия дом с компактните гардероби от Zarra Design. ⭐Поръчайте онлайн и вземете с доставка до Вашата врата!⭐'
title: 'Гардероби | Zarra Design'
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: 1763183964

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
mod_products_enabled: true
mod_products_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_HOST: zarra.bg
HTTP_IF_MODIFIED_SINCE: 'Thu, 10 Jul 2025 16:26:17 GMT'
HTTP_USER_AGENT: 'CCBot/2.0 (https://commoncrawl.org/faq/)'
OMP_THREAD_LIMIT: '1'
PATH: '/usr/local/bin:/usr/bin:/bin'
PATH_INFO: /spalnq/garderobi
PATH_TRANSLATED: 'redirect:/index.php/garderobi'
QUERY_STRING: ''
REMOTE_ADDR: 18.97.14.91
REMOTE_PORT: '38422'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_URI: /index.php/spalnq/garderobi
SCRIPT_FILENAME: /home/zarrabg/www/www/index.php
SCRIPT_NAME: /index.php
SCRIPT_URI: 'https://zarra.bg/index.php/spalnq/garderobi'
SCRIPT_URL: /index.php/spalnq/garderobi
SERVER_ADDR: 195.8.222.33
SERVER_ADMIN: admin@zarra.bg
SERVER_NAME: zarra.bg
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/2.0
SERVER_SIGNATURE: ''
SERVER_SOFTWARE: Apache
SSL_TLS_SNI: zarra.bg
TZ: Europe/Sofia
UNIQUE_ID: aRgNXDqtGb_-HyM8ZIHSqwAPNZk
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_HOST: zarra.bg
HTTP_IF_MODIFIED_SINCE: 'Thu, 10 Jul 2025 16:26:17 GMT'
HTTP_USER_AGENT: 'CCBot/2.0 (https://commoncrawl.org/faq/)'
OMP_THREAD_LIMIT: '1'
PATH: '/usr/local/bin:/usr/bin:/bin'
PATH_INFO: /spalnq/garderobi
PATH_TRANSLATED: 'redirect:/index.php/garderobi'
PHP_SELF: /index.php/spalnq/garderobi
QUERY_STRING: ''
REMOTE_ADDR: 18.97.14.91
REMOTE_PORT: '38422'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1763183964
REQUEST_URI: /index.php/spalnq/garderobi
SCRIPT_FILENAME: /home/zarrabg/www/www/index.php
SCRIPT_NAME: /index.php
SCRIPT_URI: 'https://zarra.bg/index.php/spalnq/garderobi'
SCRIPT_URL: /index.php/spalnq/garderobi
SERVER_ADDR: 195.8.222.33
SERVER_ADMIN: admin@zarra.bg
SERVER_NAME: zarra.bg
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/2.0
SERVER_SIGNATURE: ''
SERVER_SOFTWARE: Apache
SSL_TLS_SNI: zarra.bg
TZ: Europe/Sofia
UNIQUE_ID: aRgNXDqtGb_-HyM8ZIHSqwAPNZk
argc: 0
argv: { }
session: { }

php: 5.3.29 os: 'Linux s801.sureserver.com 6.6.58-sure #1 SMP PREEMPT_DYNAMIC Thu Oct 24 08:14:29 EDT 2024 x86_64' extensions: 7: bcmath 8: bz2 9: calendar 53: cgi-fcgi 0: 'Core (5.3.29)' 10: ctype 11: curl 1: 'date (5.3.29)' 12: 'dom (20031129)' 2: ereg 42: '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 54: 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)' 37: 'Phar (2.0.1)' 35: posix 36: 'Reflection ($Id: 4af6c4c676864b1c0bfa693845af0688645c37cf $)' 30: session 38: 'SimpleXML (0.1)' 39: soap 40: sockets 20: 'SPL (0.2)' 41: 'SQLite (2.0-dev)' 5: 'sqlite3 (0.7-dev)' 34: 'standard (5.3.29)' 43: 'sureacct (0.1)' 44: 'tidy (2.0)' 45: 'tokenizer (0.1)' 46: wddx 47: xml 48: 'xmlreader (0.1)' 49: 'xmlrpc (0.51)' 50: 'xmlwriter (0.1)' 51: 'xsl (0.1)' 52: 'zip (1.11.0)' 6: 'zlib (1.1)'

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

Parameters:
$id (integer)$root_id (integer)$root_slug (string)$cat_slug (string)$root_category (Category)$category (Category)$categories (Doctrine_Collection)$records (sfDoctrinePager)
Parameters:
$pager (sfDoctrinePager)
Parameters:
$is_root_category (NULL)$is_subcategory (string)$is_product (NULL)$slug (NULL)$type (NULL)$pages (array)$category (Category)
Parameters:
$categories (Doctrine_Collection)
Parameters:
$categories (Doctrine_Collection)$contacts (Doctrine_Collection)$page (Page)



| # | type | message |
|---|---|---|
| 1 | culturePatternRouting | Match route "category" (/:root_category_slug/:category_slug) for /spalnq/garderobi with parameters array ( 'module' => 'products', 'action' => 'category', 'category' => '1', 'root_category_slug' => 'spalnq', 'category_slug' => 'garderobi',) |
| 2 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 3 | sfFilterChain | Executing filter "switchLanguageFilter" |
| 4 | sfFilterChain | Executing filter "appConfigsFilter" |
| 5 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 6 | Doctrine_Connection_Mysql | query : SELECT a.id AS a__id, a.var_key AS a__var_key, a.var_value AS a__var_value FROM app_var a - () |
| 7 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 8 | productsActions | Call "productsActions->executeCategory()" |
| 9 | Doctrine_Connection_Statement | execute : SELECT DISTINCT c3.id FROM category c3 LEFT JOIN category_translation c4 ON c3.id = c4.id WHERE c4.slug = ? AND c4.lang = ? AND c4.is_published = ? ORDER BY c3.position LIMIT 1 - (spalnq, bg, 1) |
| 10 | Doctrine_Connection_Statement | execute : 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 c.id IN ('4') AND (c2.slug = ? AND c2.lang = ? AND c2.is_published = ?) ORDER BY c.position - (spalnq, bg, 1) |
| 11 | Doctrine_Connection_Statement | execute : SELECT DISTINCT c3.id FROM category c3 LEFT JOIN category_translation c4 ON c3.id = c4.id WHERE c4.lang = ? AND c4.slug = ? AND c4.is_published = ? LIMIT 1 - (bg, garderobi, 1) |
| 12 | Doctrine_Connection_Statement | execute : 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 c.id IN ('49') AND (c2.lang = ? AND c2.slug = ? AND c2.is_published = ?) - (bg, garderobi, 1) |
| 13 | Doctrine_Connection_Statement | execute : 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 = ? AND (c.parent_id IS NULL OR c.parent_id = 0) AND c2.is_published = ?) ORDER BY c.position - (bg, 1) |
| 14 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE p2.lang = ? AND p.category_id = ? AND p.is_active = ? GROUP BY p.id) dctrn_count_query - (bg, 49, 1) |
| 15 | sfPHPView | Render "sf_app_dir/modules/products/templates/categorySuccess.php" |
| 16 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 4) |
| 17 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.category_id AS p__category_id, p.price AS p__price, p.promo_price AS p__promo_price, p.stock AS p__stock, p.is_active AS p__is_active, p.is_new AS p__is_new, 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.body AS p2__body, p2.tab_title1 AS p2__tab_title1, p2.body1 AS p2__body1, p2.tab_title2 AS p2__tab_title2, p2.body2 AS p2__body2, p2.tab_title3 AS p2__tab_title3, p2.body3 AS p2__body3, p2.tab_title4 AS p2__tab_title4, p2.body4 AS p2__body4, p2.tab_title5 AS p2__tab_title5, p2.body5 AS p2__body5, p2.tab_title6 AS p2__tab_title6, p2.body6 AS p2__body6, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ? AND p.is_active = ?) ORDER BY p.position, p.id - (bg, 49, 1) |
| 18 | sfPartialView | Render "sf_app_dir/modules/common/templates/_pager.php" |
| 19 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 20 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 21 | main | Call "common->executeTitle()" |
| 22 | Doctrine_Connection_Statement | execute : 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.slug = ?) - (garderobi) |
| 23 | sfPartialView | Render "sf_app_dir/modules/common/templates/_title.php" |
| 24 | Doctrine_Connection_Statement | execute : 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) |
| 25 | main | Call "common->executeTopMenu()" |
| 26 | Doctrine_Connection_Statement | execute : 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 = ? AND (c.parent_id IS NULL OR c.parent_id = 0) AND c2.is_published = ?) ORDER BY c.position - (bg, 1) |
| 27 | sfPartialView | Render "sf_app_dir/modules/common/templates/_topMenu.php" |
| 28 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 2) |
| 29 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 2) |
| 30 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 1) |
| 31 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 1) |
| 32 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 3) |
| 33 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 3) |
| 34 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 4) |
| 35 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 4) |
| 36 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 5) |
| 37 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 5) |
| 38 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 6) |
| 39 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 6) |
| 40 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 7) |
| 41 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 7) |
| 42 | Doctrine_Connection_Statement | execute : 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 = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 8) |
| 43 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 8) |
| 44 | main | Call "common->executeFooter()" |
| 45 | Doctrine_Connection_Statement | execute : 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 = ? AND (c.parent_id IS NULL OR c.parent_id = 0) AND c2.is_published = ?) ORDER BY c.position - (bg, 1) |
| 46 | Doctrine_Connection_Statement | execute : 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 = ? AND p2.lang = ? AND p2.is_published = ?) ORDER BY p.position - (4, bg, 1) |
| 47 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p3.id FROM page p3 LEFT JOIN page_translation p4 ON p3.id = p4.id WHERE p3.type = ? AND p4.lang = ? AND p4.is_published = ? ORDER BY p3.position LIMIT 1 - (1, bg, 1) |
| 48 | Doctrine_Connection_Statement | execute : 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 = ? AND p2.lang = ? AND p2.is_published = ?) ORDER BY p.position - (1, bg, 1) |
| 49 | sfPartialView | Render "sf_app_dir/modules/common/templates/_footer.php" |
| 50 | main | Call "common->executeNewsletter()" |
| 51 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p3.id FROM page p3 LEFT JOIN page_translation p4 ON p3.id = p4.id WHERE p3.type = ? AND p4.lang = ? AND p4.is_published = ? ORDER BY p3.position LIMIT 1 - (10, bg, 1) |
| 52 | Doctrine_Connection_Statement | execute : 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 = ? AND p2.lang = ? AND p2.is_published = ?) ORDER BY p.position - (10, bg, 1) |
| 53 | sfPartialView | Render "sf_app_dir/modules/common/templates/_newsletter.php" |
| 54 | sfWebResponse | Send status "HTTP/2.0 200 OK" |
| 55 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 19 | 36.91 | 8 |
| Factories | 1 | 27.79 | 6 |
| Database (Doctrine) | 35 | 0.07 | 0 |
| Action "products/category" | 1 | 88.25 | 20 |
| View "Success" for "products/category" | 1 | 232.58 | 54 |
| Partial "common/_pager" | 1 | 0.53 | 0 |
| Component "common/title" | 1 | 3.74 | 0 |
| Partial "common/_title" | 1 | 0.86 | 0 |
| Component "common/topMenu" | 1 | 10.14 | 2 |
| Partial "common/_topMenu" | 1 | 110.95 | 25 |
| Component "common/footer" | 1 | 24.30 | 5 |
| Partial "common/_footer" | 1 | 16.73 | 3 |
| Component "common/newsletter" | 1 | 14.35 | 3 |
| Partial "common/_newsletter" | 1 | 2.47 | 0 |
SET NAMES 'UTF8'
SELECT a.id AS a__id, a.var_key AS a__var_key, a.var_value AS a__var_value FROM app_var a
SELECT DISTINCT c3.id FROM category c3 LEFT JOIN category_translation c4 ON c3.id = c4.id WHERE c4.slug = 'spalnq' AND c4.lang = 'bg' AND c4.is_published = '1' ORDER BY c3.position LIMIT 1
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 c.id IN ('4') AND (c2.slug = 'spalnq' AND c2.lang = 'bg' AND c2.is_published = '1') ORDER BY c.position
SELECT DISTINCT c3.id FROM category c3 LEFT JOIN category_translation c4 ON c3.id = c4.id WHERE c4.lang = 'bg' AND c4.slug = 'garderobi' AND c4.is_published = '1' LIMIT 1
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 c.id IN ('49') AND (c2.lang = 'bg' AND c2.slug = 'garderobi' AND c2.is_published = '1')
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
SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE p2.lang = 'bg' AND p.category_id = '49' AND p.is_active = '1' GROUP BY p.id) dctrn_count_query
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
SELECT p.id AS p__id, p.category_id AS p__category_id, p.price AS p__price, p.promo_price AS p__promo_price, p.stock AS p__stock, p.is_active AS p__is_active, p.is_new AS p__is_new, 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.body AS p2__body, p2.tab_title1 AS p2__tab_title1, p2.body1 AS p2__body1, p2.tab_title2 AS p2__tab_title2, p2.body2 AS p2__body2, p2.tab_title3 AS p2__tab_title3, p2.body3 AS p2__body3, p2.tab_title4 AS p2__tab_title4, p2.body4 AS p2__body4, p2.tab_title5 AS p2__tab_title5, p2.body5 AS p2__body5, p2.tab_title6 AS p2__tab_title6, p2.body6 AS p2__body6, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = 'bg' AND p.category_id = '49' AND p.is_active = '1') ORDER BY p.position, p.id
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.slug = 'garderobi')
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')
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
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
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')
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
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')
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
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')
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
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')
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
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')
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
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')
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
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')
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
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')
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
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
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
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
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
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

