Mattresses Koral
Latex mattress Coral will guarantee quality at a reasonable price. Due to its higher density and hardness compared to other mattresses it provides comfort and relaxation to all who prefer harder surfaces for their holiday.
Mattresses
Latex mattress Coral will guarantee quality at a reasonable price. Due to its higher density and hardness compared to other mattresses it provides comfort and relaxation to all who prefer harder surfaces for their holiday.
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: product category_slug: mattresses module: products product: '1' product_slug: mattresses-koral root_category_slug: bedroom sf_culture: en 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: { } /js/front/jquery-ui.js: { } /js/front/jquery.jcarousel.js: { } /js/front/jcarousel.responsive_product.js: { } /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: { } /css/front/jquery-ui.css: { } /css/front/skin.css: { } /css/front/jcarousel.responsive.css: { } /css/front/jquery.fancybox.css: { } front/bootstrap.css: { } front/style.css: { } metas: keywords: 'Mattresses Koral' description: 'Mattresses Koral' title: 'Mattresses Koral' httpMetas: Content-Type: 'text/html; charset=utf-8'
options: auto_shutdown: false culture: en 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: en authenticated: false credentials: { } lastRequest: 1713526571
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: '*/*' HTTP_HOST: zarra.bg HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' OMP_THREAD_LIMIT: '1' PATH: '/usr/local/bin:/usr/bin:/bin' PATH_INFO: /bedroom/mattresses/mattresses-koral/en PATH_TRANSLATED: 'redirect:/index.php/mattresses/mattresses-koral/en' QUERY_STRING: '' REMOTE_ADDR: 18.220.160.216 REMOTE_PORT: '16876' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_URI: /index.php/bedroom/mattresses/mattresses-koral/en 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/2.0 SERVER_SIGNATURE: '' SERVER_SOFTWARE: Apache SSL_TLS_SNI: zarra.bg TZ: Europe/Sofia UNIQUE_ID: ZiJXK5DCYODFwQPVE3IjtwAZ0DA 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: '*/*' HTTP_HOST: zarra.bg HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' OMP_THREAD_LIMIT: '1' PATH: '/usr/local/bin:/usr/bin:/bin' PATH_INFO: /bedroom/mattresses/mattresses-koral/en PATH_TRANSLATED: 'redirect:/index.php/mattresses/mattresses-koral/en' PHP_SELF: /index.php/bedroom/mattresses/mattresses-koral/en QUERY_STRING: '' REMOTE_ADDR: 18.220.160.216 REMOTE_PORT: '16876' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1713526571 REQUEST_URI: /index.php/bedroom/mattresses/mattresses-koral/en 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/2.0 SERVER_SIGNATURE: '' SERVER_SOFTWARE: Apache SSL_TLS_SNI: zarra.bg TZ: Europe/Sofia UNIQUE_ID: ZiJXK5DCYODFwQPVE3IjtwAZ0DA argc: 0 argv: { } session: { }
php: 5.3.29 os: 'Linux s801.sureserver.com 5.15.146-sure #1 SMP Mon Jan 15 05:59:48 EST 2024 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:
$root_category_slug
(string)$cat_slug
(string)$id
(integer)$slug
(string)$product
(Product)$images
(Doctrine_Collection)$tab_images
(Doctrine_Collection)$category
(Category)$root_category
(Category)Parameters:
$is_root_category
(NULL)$is_subcategory
(NULL)$is_product
(string)$slug
(NULL)$type
(NULL)$pages
(array)$product
(Product)$category
(Category)Parameters:
$categories
(Doctrine_Collection)Parameters:
$categories
(Doctrine_Collection)$contacts
(Doctrine_Collection)$page
(Page)# | type | message |
---|---|---|
1 | culturePatternRouting | Match route "product_i18n" (/:root_category_slug/:category_slug/:product_slug/:sf_culture) for /bedroom/mattresses/mattresses-koral/en with parameters array ( 'module' => 'products', 'action' => 'product', 'product' => '1', 'root_category_slug' => 'bedroom', 'category_slug' => 'mattresses', 'product_slug' => 'mattresses-koral', 'sf_culture' => 'en',) |
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->executeProduct()" |
9 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id WHERE p4.slug = ? AND p4.lang = ? AND p3.is_active = ? LIMIT 1 - (mattresses-koral, en, 1) |
10 | 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 p.id IN ('397') AND (p2.slug = ? AND p2.lang = ? AND p.is_active = ?) - (mattresses-koral, en, 1) |
11 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f.tbl_name AS f__tbl_name, f.tbl_id AS f__tbl_id, f.type AS f__type, f.file AS f__file, f.is_active AS f__is_active, f.position AS f__position, f.created_at AS f__created_at, f.updated_at AS f__updated_at, f2.id AS f2__id, f2.title AS f2__title, f2.text_title AS f2__text_title, f2.text AS f2__text, f2.link AS f2__link, f2.is_published AS f2__is_published, f2.lang AS f2__lang FROM file f LEFT JOIN file_translation f2 ON f.id = f2.id WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position - (product, 397, 1, 1) |
12 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f.tbl_name AS f__tbl_name, f.tbl_id AS f__tbl_id, f.type AS f__type, f.file AS f__file, f.is_active AS f__is_active, f.position AS f__position, f.created_at AS f__created_at, f.updated_at AS f__updated_at, f2.id AS f2__id, f2.title AS f2__title, f2.text_title AS f2__text_title, f2.text AS f2__text, f2.link AS f2__link, f2.is_published AS f2__is_published, f2.lang AS f2__lang FROM file f LEFT JOIN file_translation f2 ON f.id = f2.id WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position - (product, 397, 4, 1) |
13 | 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 - (mattresses, en, 1) |
14 | 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 ('23') AND (c2.slug = ? AND c2.lang = ? AND c2.is_published = ?) ORDER BY c.position - (mattresses, en, 1) |
15 | 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 - (mattresses, en, 1) |
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 c.id IN ('23') AND (c2.slug = ? AND c2.lang = ? AND c2.is_published = ?) ORDER BY c.position - (mattresses, en, 1) |
17 | sfPHPView | Render "sf_app_dir/modules/products/templates/productSuccess.php" |
18 | 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 FROM category c WHERE (c.id = ?) - (4) |
19 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.title AS c__title, c.slug AS c__slug, c.body AS c__body, c.meta_title AS c__meta_title, c.meta_keywords AS c__meta_keywords, c.meta_description AS c__meta_description, c.is_published AS c__is_published, c.lang AS c__lang FROM category_translation c WHERE (c.id IN (?)) - (4) |
20 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id WHERE p4.lang = ? AND p3.category_id = ? AND p3.is_active = ? AND (p3.position < 20 OR (p3.position = 20 AND p3.id < 397)) ORDER BY p3.position DESC, p3.id DESC LIMIT 1 - (en, 23, 1) |
21 | 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 p.id IN ('193') AND (p2.lang = ? AND p.category_id = ? AND p.is_active = ? AND (p.position < 20 OR (p.position = 20 AND p.id < 397))) ORDER BY p.position DESC, p.id DESC - (en, 23, 1) |
22 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id WHERE p4.lang = ? AND p3.category_id = ? AND p3.is_active = ? AND (p3.position > 20 OR (p3.position = 20 AND p3.id > 397)) ORDER BY p3.position , p3.id LIMIT 1 - (en, 23, 1) |
23 | 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 p.id IN ('398') AND (p2.lang = ? AND p.category_id = ? AND p.is_active = ? AND (p.position > 20 OR (p.position = 20 AND p.id > 397))) ORDER BY p.position , p.id - (en, 23, 1) |
24 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 397, 1, 1) |
25 | 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_en) |
26 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
27 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
28 | main | Call "common->executeTitle()" |
29 | 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.slug = ?) - (mattresses-koral) |
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.slug = ?) - (mattresses) |
31 | sfPartialView | Render "sf_app_dir/modules/common/templates/_title.php" |
32 | 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_en) |
33 | main | Call "common->executeTopMenu()" |
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 IS NULL OR c.parent_id = 0) AND c2.is_published = ?) ORDER BY c.position - (en, 1) |
35 | sfPartialView | Render "sf_app_dir/modules/common/templates/_topMenu.php" |
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 - (en, 2) |
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 = ?) - (en, 2) |
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 - (en, 1) |
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 = ?) - (en, 1) |
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 - (en, 3) |
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 = ?) - (en, 3) |
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 - (en, 4) |
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 = ?) - (en, 4) |
44 | 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 - (en, 5) |
45 | 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 = ?) - (en, 5) |
46 | 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 - (en, 6) |
47 | 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 = ?) - (en, 6) |
48 | 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 - (en, 7) |
49 | 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 = ?) - (en, 7) |
50 | 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 - (en, 8) |
51 | 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 = ?) - (en, 8) |
52 | main | Call "common->executeFooter()" |
53 | 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 - (en, 1) |
54 | 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, en, 1) |
55 | 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, en, 1) |
56 | 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, en, 1) |
57 | sfPartialView | Render "sf_app_dir/modules/common/templates/_footer.php" |
58 | main | Call "common->executeNewsletter()" |
59 | 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, en, 1) |
60 | 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, en, 1) |
61 | sfPartialView | Render "sf_app_dir/modules/common/templates/_newsletter.php" |
62 | sfWebResponse | Send status "HTTP/2.0 200 OK" |
63 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 19 | 20.72 | 7 |
Factories | 1 | 17.05 | 6 |
Database (Doctrine) | 44 | 0.05 | 0 |
Action "products/product" | 1 | 70.31 | 26 |
View "Success" for "products/product" | 1 | 135.86 | 51 |
Component "common/title" | 1 | 10.08 | 3 |
Partial "common/_title" | 1 | 1.07 | 0 |
Component "common/topMenu" | 1 | 6.69 | 2 |
Partial "common/_topMenu" | 1 | 50.48 | 18 |
Component "common/footer" | 1 | 10.94 | 4 |
Partial "common/_footer" | 1 | 5.79 | 2 |
Component "common/newsletter" | 1 | 7.92 | 2 |
Partial "common/_newsletter" | 1 | 2.78 | 1 |
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 p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id WHERE p4.slug = 'mattresses-koral' AND p4.lang = 'en' AND p3.is_active = '1' LIMIT 1
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 p.id IN ('397') AND (p2.slug = 'mattresses-koral' AND p2.lang = 'en' AND p.is_active = '1')
SELECT f.id AS f__id, f.tbl_name AS f__tbl_name, f.tbl_id AS f__tbl_id, f.type AS f__type, f.file AS f__file, f.is_active AS f__is_active, f.position AS f__position, f.created_at AS f__created_at, f.updated_at AS f__updated_at, f2.id AS f2__id, f2.title AS f2__title, f2.text_title AS f2__text_title, f2.text AS f2__text, f2.link AS f2__link, f2.is_published AS f2__is_published, f2.lang AS f2__lang FROM file f LEFT JOIN file_translation f2 ON f.id = f2.id WHERE (f.tbl_name = 'product' AND f.tbl_id = '397' AND f.type = '1' AND f.is_active = '1') ORDER BY f.position
SELECT f.id AS f__id, f.tbl_name AS f__tbl_name, f.tbl_id AS f__tbl_id, f.type AS f__type, f.file AS f__file, f.is_active AS f__is_active, f.position AS f__position, f.created_at AS f__created_at, f.updated_at AS f__updated_at, f2.id AS f2__id, f2.title AS f2__title, f2.text_title AS f2__text_title, f2.text AS f2__text, f2.link AS f2__link, f2.is_published AS f2__is_published, f2.lang AS f2__lang FROM file f LEFT JOIN file_translation f2 ON f.id = f2.id WHERE (f.tbl_name = 'product' AND f.tbl_id = '397' AND f.type = '4' AND f.is_active = '1') ORDER BY f.position
SELECT DISTINCT c3.id FROM category c3 LEFT JOIN category_translation c4 ON c3.id = c4.id WHERE c4.slug = 'mattresses' AND c4.lang = 'en' 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 ('23') AND (c2.slug = 'mattresses' AND c2.lang = 'en' 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.slug = 'mattresses' AND c4.lang = 'en' 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 ('23') AND (c2.slug = 'mattresses' AND c2.lang = 'en' 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 FROM category c WHERE (c.id = '4')
SELECT c.id AS c__id, c.title AS c__title, c.slug AS c__slug, c.body AS c__body, c.meta_title AS c__meta_title, c.meta_keywords AS c__meta_keywords, c.meta_description AS c__meta_description, c.is_published AS c__is_published, c.lang AS c__lang FROM category_translation c WHERE (c.id IN ('4'))
SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id WHERE p4.lang = 'en' AND p3.category_id = '23' AND p3.is_active = '1' AND (p3.position < 20 OR (p3.position = 20 AND p3.id < 397)) ORDER BY p3.position DESC, p3.id DESC LIMIT 1
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 p.id IN ('193') AND (p2.lang = 'en' AND p.category_id = '23' AND p.is_active = '1' AND (p.position < 20 OR (p.position = 20 AND p.id < 397))) ORDER BY p.position DESC, p.id DESC
SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id WHERE p4.lang = 'en' AND p3.category_id = '23' AND p3.is_active = '1' AND (p3.position > 20 OR (p3.position = 20 AND p3.id > 397)) ORDER BY p3.position , p3.id LIMIT 1
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 p.id IN ('398') AND (p2.lang = 'en' AND p.category_id = '23' AND p.is_active = '1' AND (p.position > 20 OR (p.position = 20 AND p.id > 397))) ORDER BY p.position , p.id
SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = 'product' AND f.tbl_id = '397' AND f.type = '1' AND f.is_active = '1') ORDER BY f.position LIMIT 1
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_en')
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.slug = 'mattresses-koral')
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 = 'mattresses')
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_en')
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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' AND p2.is_published = '1') ORDER BY p.position