Modern table
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: modern-table module: products product: '1' product_slug: dining-table-rubi root_category_slug: dining-room 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: { } 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: 1733604911
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_USER_AGENT: 'CCBot/2.0 (https://commoncrawl.org/faq/)' OMP_THREAD_LIMIT: '1' PATH: '/usr/local/bin:/usr/bin:/bin' PATH_INFO: /dining-room/modern-table/dining-table-rubi/en PATH_TRANSLATED: 'redirect:/index.php/modern-table/dining-table-rubi/en' QUERY_STRING: '' REMOTE_ADDR: 18.97.9.171 REMOTE_PORT: '49782' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_URI: /index.php/dining-room/modern-table/dining-table-rubi/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: Z1S2Lz9KJiD4D-ah2AMQxQAVcCU 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_USER_AGENT: 'CCBot/2.0 (https://commoncrawl.org/faq/)' OMP_THREAD_LIMIT: '1' PATH: '/usr/local/bin:/usr/bin:/bin' PATH_INFO: /dining-room/modern-table/dining-table-rubi/en PATH_TRANSLATED: 'redirect:/index.php/modern-table/dining-table-rubi/en' PHP_SELF: /index.php/dining-room/modern-table/dining-table-rubi/en QUERY_STRING: '' REMOTE_ADDR: 18.97.9.171 REMOTE_PORT: '49782' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1733604911 REQUEST_URI: /index.php/dining-room/modern-table/dining-table-rubi/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: Z1S2Lz9KJiD4D-ah2AMQxQAVcCU 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 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 /dining-room/modern-table/dining-table-rubi/en with parameters array ( 'module' => 'products', 'action' => 'product', 'product' => '1', 'root_category_slug' => 'dining-room', 'category_slug' => 'modern-table', 'product_slug' => 'dining-table-rubi', '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 - (dining-table-rubi, 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 ('822') AND (p2.slug = ? AND p2.lang = ? AND p.is_active = ?) - (dining-table-rubi, 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, 822, 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, 822, 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 - (modern-table, 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 ('27') AND (c2.slug = ? AND c2.lang = ? AND c2.is_published = ?) ORDER BY c.position - (modern-table, 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 - (modern-table, 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 ('27') AND (c2.slug = ? AND c2.lang = ? AND c2.is_published = ?) ORDER BY c.position - (modern-table, 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 = ?) - (3) |
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 (?)) - (3) |
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 < 17 OR (p3.position = 17 AND p3.id < 822)) ORDER BY p3.position DESC, p3.id DESC LIMIT 1 - (en, 27, 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 ('1058') AND (p2.lang = ? AND p.category_id = ? AND p.is_active = ? AND (p.position < 17 OR (p.position = 17 AND p.id < 822))) ORDER BY p.position DESC, p.id DESC - (en, 27, 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 > 17 OR (p3.position = 17 AND p3.id > 822)) ORDER BY p3.position , p3.id LIMIT 1 - (en, 27, 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 ('731') AND (p2.lang = ? AND p.category_id = ? AND p.is_active = ? AND (p.position > 17 OR (p.position = 17 AND p.id > 822))) ORDER BY p.position , p.id - (en, 27, 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, 822, 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 = ?) - (dining-table-rubi) |
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 = ?) - (modern-table) |
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 | 19.09 | 8 |
Factories | 1 | 16.31 | 7 |
Database (Doctrine) | 44 | 0.05 | 0 |
Action "products/product" | 1 | 49.45 | 22 |
View "Success" for "products/product" | 1 | 118.92 | 53 |
Component "common/title" | 1 | 7.04 | 3 |
Partial "common/_title" | 1 | 0.69 | 0 |
Component "common/topMenu" | 1 | 3.94 | 1 |
Partial "common/_topMenu" | 1 | 47.21 | 21 |
Component "common/footer" | 1 | 11.31 | 5 |
Partial "common/_footer" | 1 | 6.06 | 2 |
Component "common/newsletter" | 1 | 7.73 | 3 |
Partial "common/_newsletter" | 1 | 1.34 | 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 p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id WHERE p4.slug = 'dining-table-rubi' 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 ('822') AND (p2.slug = 'dining-table-rubi' 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 = '822' 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 = '822' 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 = 'modern-table' 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 ('27') AND (c2.slug = 'modern-table' 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 = 'modern-table' 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 ('27') AND (c2.slug = 'modern-table' 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 = '3')
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 ('3'))
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 = '27' AND p3.is_active = '1' AND (p3.position < 17 OR (p3.position = 17 AND p3.id < 822)) 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 ('1058') AND (p2.lang = 'en' AND p.category_id = '27' AND p.is_active = '1' AND (p.position < 17 OR (p.position = 17 AND p.id < 822))) 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 = '27' AND p3.is_active = '1' AND (p3.position > 17 OR (p3.position = 17 AND p3.id > 822)) 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 ('731') AND (p2.lang = 'en' AND p.category_id = '27' AND p.is_active = '1' AND (p.position > 17 OR (p.position = 17 AND p.id > 822))) ORDER BY p.position , p.id
SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = 'product' AND f.tbl_id = '822' 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 = 'dining-table-rubi')
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 = 'modern-table')
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