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: brand module: pageProduct page: '28' slug: rattan-products attributeHolder: sf_route: 'sfRoute Object()'
status: code: 200 text: OK options: http_protocol: HTTP/1.1 logging: '1' charset: utf-8 send_http_headers: false content_type: 'text/html; charset=utf-8' cookies: { } httpHeaders: Content-Type: 'text/html; charset=utf-8' javascripts: jquery-1.10.1.min.js: { } jquery.form.min.js: { } jquery-ui-1.10.3.custom.min.js: { } jquery.mmenu.min.all.js: { } script.js: { } swiper.js: { } jquery.flexslider.js: { } stylesheets: jquery-ui.css: { } font-awesome-4.2.0/css/font-awesome.min.css: { } lato/css/lato.min.css: { } swiper.css: { } jquery.mmenu.all.css: { } style.css: { } a.css: { } grid.css: { } flexslider.css: { } metas: { } httpMetas: Content-Type: 'text/html; charset=utf-8'
options: auto_shutdown: false culture: null default_culture: vi use_flash: true logging: '1' timeout: 1800 attributeHolder: { } culture: vi authenticated: false credentials: { } lastRequest: 1735434600
app_ManageAdChainImage_maxsize: 999999 app_ManageAdChainImage_prefix: chain app_ManageAdChainImage_type: image/jpeg|image/jpg|image/png|image/gif app_addcslashes_charlist: '%_-\''' app_advertise_images: advertise app_album_images: album app_article_images: article app_cat_id: 2 app_category_images: category_images app_ckeditor_basePath: /js/ckeditor app_ckfinder_active: true app_ckfinder_basePath: /js/ckfinder app_document: document app_domain: 'http://kingcraftviet.com' app_excel_max_row: 1000 app_footer_id: 12 app_image_default_image_125_80: /img/image_125_80.jpg app_image_default_image_150_100: /img/image_150_100.png app_image_default_image_75_70: /img/image_75_70.png app_image_default_image_92_55: /img/image_92_55.jpg app_image_default_image_default: /img/image_default.png app_image_default_image_hot: /img/image_hot.png app_image_maxsize: 52428800 app_image_upload_max_size: 52428800 app_import_max_size: 1048576 app_member_images: member app_product_images: products app_seo_description: 'KING CRAFT VIET' app_seo_keywords: 'KING CRAFT VIET' app_seo_ogImage: '' app_seo_title: 'KING CRAFT VIET' app_seo_url: 'http://kingcraftviet.com' app_service_images: service app_sf_captchagd_chars: 2345678abcdefhjkmnprsuxyz app_sf_captchagd_charset: ABCDEFGHJKLMNPRSTUXYZabcdefghkmnprstuyz23456789 app_sf_captchagd_code_length_max: 2 app_sf_captchagd_code_length_min: 2 app_sf_captchagd_font_size: 20 app_sf_captchagd_fonts: - akbar/vavobi.ttf app_sf_captchagd_force_new_captcha: true app_sf_captchagd_image_bg_color: ffffff app_sf_captchagd_image_height: 30 app_sf_captchagd_image_width: 90 app_sf_captchagd_length: 2 app_sf_captchagd_line_color: 616161 app_sf_captchagd_noise_level: 2 app_sf_captchagd_num_lines: 1 app_sf_captchagd_perturbation: 0.3 app_sf_captchagd_text_color: 252525 app_sf_captchagd_text_transparency_percentage: 10 app_sf_captchagd_use_transparent_text: true app_tmcTwitterBootstrapPlugin_admin_js_path: /tmcTwitterBootstrapPlugin/js/global.js app_tmcTwitterBootstrapPlugin_admin_styles_path: /tmcTwitterBootstrapPlugin/css/styles.css app_tmcTwitterBootstrapPlugin_bootstrap_js_path: /tmcTwitterBootstrapPlugin/js/bootstrap.min.js app_tmcTwitterBootstrapPlugin_bootstrap_path: /tmcTwitterBootstrapPlugin/css/bootstrap.min.css app_tmcTwitterBootstrapPlugin_jquery_path: /tmcTwitterBootstrapPlugin/js/jquery.min.js app_tmcTwitterBootstrapPlugin_responsive_bootstrap_path: /tmcTwitterBootstrapPlugin/css/bootstrap-responsive.min.css app_upload_max_size: 104857600 app_upload_media_file: /root/apps/project/kingcraftviet/web/uploads app_upload_member: /root/apps/project/kingcraftviet/web/uploads app_upload_video_max_size: 50485760 app_url_media_default_file: 'http://kingcraftviet.com/images/default-image.jpg' app_url_media_file: /uploads app_video_images: video ex_meta_category: cdsa ex_meta_creator: 'abc xyz' ex_meta_description: dsad ex_meta_keywords: dsad ex_meta_subject: dsad ex_meta_title: asdsa mod_modulemenu_enabled: true mod_modulemenu_view_class: sfPHP mod_pagehome_enabled: true mod_pagehome_view_class: sfPHP mod_pageproduct_enabled: true mod_pageproduct_view_class: sfPHP sf_admin_module_web_dir: /sfDoctrinePlugin sf_admin_web_dir: /sf/sf_admin sf_app: frontend sf_app_base_cache_dir: /root/apps/project/kingcraftviet/cache/frontend sf_app_cache_dir: /root/apps/project/kingcraftviet/cache/frontend/dev sf_app_config_dir: /root/apps/project/kingcraftviet/apps/frontend/config sf_app_dir: /root/apps/project/kingcraftviet/apps/frontend sf_app_i18n_dir: /root/apps/project/kingcraftviet/apps/frontend/i18n sf_app_lib_dir: /root/apps/project/kingcraftviet/apps/frontend/lib sf_app_module_dir: /root/apps/project/kingcraftviet/apps/frontend/modules sf_app_template_dir: /root/apps/project/kingcraftviet/apps/frontend/templates sf_apps_dir: /root/apps/project/kingcraftviet/apps sf_cache: false sf_cache_dir: /root/apps/project/kingcraftviet/cache sf_charset: utf-8 sf_check_lock: false sf_compressed: false sf_config_cache_dir: /root/apps/project/kingcraftviet/cache/frontend/dev/config sf_config_dir: /root/apps/project/kingcraftviet/config sf_csrf_secret: UniqueSecret sf_data_dir: /root/apps/project/kingcraftviet/data sf_debug: true sf_default_culture: vi sf_enabled_modules: - sfCaptchaGD - vtCaptchaGD sf_environment: dev sf_error_404_action: error404 sf_error_404_module: default sf_error_reporting: 24575 sf_escaping_method: ESC_SPECIALCHARS sf_escaping_strategy: false sf_etag: false sf_file_link_format: null sf_i18n: true sf_i18n_cache_dir: /root/apps/project/kingcraftviet/cache/frontend/dev/i18n sf_lib_dir: /root/apps/project/kingcraftviet/lib sf_log_dir: /root/apps/project/kingcraftviet/log sf_logging_enabled: true sf_login_action: login sf_login_module: default sf_module_cache_dir: /root/apps/project/kingcraftviet/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: /root/apps/project/kingcraftviet/plugins sf_root_dir: /root/apps/project/kingcraftviet sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Cache - I18N sf_symfony_lib_dir: /root/apps/project/kingcraftviet/lib/vendor/symfony/lib sf_template_cache_dir: /root/apps/project/kingcraftviet/cache/frontend/dev/template sf_test_cache_dir: /root/apps/project/kingcraftviet/cache/frontend/dev/test sf_test_dir: /root/apps/project/kingcraftviet/test sf_upload_dir: /root/apps/project/kingcraftviet/web/uploads sf_use_database: true sf_web_debug: true sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /root/apps/project/kingcraftviet/web
cookie: { } env: { } files: { } get: { } post: { } server: CONTENT_LENGTH: '' CONTENT_TYPE: '' DOCUMENT_ROOT: /root/apps/project/kingcraftviet/web DOCUMENT_URI: /frontend.php/brand/rattan-products/28 FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: / HTTPS: on HTTP_ACCEPT: '*/*' HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate' HTTP_HOST: kingcraftviet.com HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' PHP_SELF: /frontend.php QUERY_STRING: '' REDIRECT_STATUS: '200' REMOTE_ADDR: 18.189.143.150 REMOTE_PORT: '51066' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1735434600 REQUEST_TIME_FLOAT: 1735434600.0084 REQUEST_URI: /frontend.php/brand/rattan-products/28 SCRIPT_FILENAME: /root/apps/project/kingcraftviet/web/frontend.php SCRIPT_NAME: /frontend.php SERVER_ADDR: 163.44.193.86 SERVER_NAME: kingcraftviet.com SERVER_PORT: '443' SERVER_PROTOCOL: HTTP/1.1 SERVER_SOFTWARE: nginx/1.9.9 USER: nobody session: { }
php: 5.6.17 os: 'Linux host-163-44-193-86 2.6.32-754.12.1.el6.x86_64 #1 SMP Tue Apr 9 14:52:26 UTC 2019 x86_64' extensions: 8: calendar 41: cgi-fcgi 0: 'Core (5.6.17)' 9: ctype 10: curl 1: 'date (5.6.17)' 11: 'dom (20031129)' 2: ereg 35: 'exif (1.4 $Id: a0425de51ec3270d01522bf62d41bfe78893f78d $)' 13: 'fileinfo (1.0.5)' 14: 'filter (0.11.0)' 15: ftp 16: gd 12: 'hash (1.0)' 18: iconv 19: 'json (1.2.1)' 3: libxml 20: mbstring 21: mcrypt 32: 'mysql (1.0)' 25: 'mysqli (0.1)' 24: 'mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $)' 4: openssl 5: pcre 26: 'PDO (1.0.4dev)' 27: 'pdo_mysql (1.0.2)' 28: 'pdo_sqlite (1.0.1)' 29: 'Phar (2.0.2)' 30: posix 31: 'Reflection ($Id: e1a2c576686e394757985fc88c2e6243ab2bb511 $)' 22: session 33: 'SimpleXML (0.1)' 34: soap 17: 'SPL (0.2)' 6: 'sqlite3 (0.7-dev)' 23: 'standard (5.6.17)' 36: 'tokenizer (0.1)' 37: xml 38: 'xmlreader (0.1)' 39: 'xmlwriter (0.1)' 40: 'zip (1.12.5)' 7: 'zlib (2.0)'
version: 1.4.20 path: /root/apps/project/kingcraftviet/lib/vendor/symfony/lib
Parameters:
$pager
(sfDoctrinePager)$category
(HqBrand)$page
(string)Parameters:
$data
(array)Parameters:
$products
(Doctrine_Collection)Parameters:
$data
(array)$services
(array)No parameters were passed to this template.
Parameters:
$form
(InquiryNowFront)
$form['full_name']
(sfWidgetFormInputText)
$form['email']
(sfWidgetFormInputText)
$form['phone']
(sfWidgetFormInputText)
$form['body']
(sfWidgetFormTextarea)
$form['address']
(sfWidgetFormInputText)
$form['shipping_term']
(sfWidgetFormInputText)
$form['requirement']
(sfWidgetFormTextarea)
$form['lang']
(sfWidgetFormInputText)
$form['country']
(sfWidgetFormInputText)
$form['_csrf_token']
(sfWidgetFormInputHidden)
# | type | message |
---|---|---|
1 | sfPatternRouting | Connect sfRequestRoute "sf_captchagd" (/captcha) |
2 | sfPatternRouting | Match route "hq_brand" (/brand/:slug/:page) for /brand/rattan-products/28 with parameters array ( 'module' => 'pageProduct', 'action' => 'brand', 'page' => '28', 'slug' => 'rattan-products',) |
3 | sfFilterChain | Executing filter "sfRenderingFilter" |
4 | sfFilterChain | Executing filter "ChangeLanguageFilter" |
5 | sfFilterChain | Executing filter "sfExecutionFilter" |
6 | pageProductActions | Call "pageProductActions->executeBrand()" |
7 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
8 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.slug = ?) - (rattan-products) |
9 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM vtp_products v WHERE v.brand = ? AND v.is_active = ? - (5, 1) |
10 | sfPHPView | Render "sf_app_dir/modules/pageProduct/templates/brandSuccess.php" |
11 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.product_code AS v__product_code, v.category_id AS v__category_id, v.price AS v__price, v.price_promotion AS v__price_promotion, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.description AS v__description, v.content AS v__content, v.comment AS v__comment, v.warranty_information AS v__warranty_information, v.manufacturer AS v__manufacturer, v.accessories AS v__accessories, v.is_active AS v__is_active, v.is_home AS v__is_home, v.is_hot AS v__is_hot, v.slug AS v__slug, v.portal_id AS v__portal_id, v.lang AS v__lang, v.meta AS v__meta, v.keywords AS v__keywords, v.brand AS v__brand, v.reference_price AS v__reference_price, v.unit AS v__unit, v.origin AS v__origin, v.payment AS v__payment, v.delivery AS v__delivery, v.port AS v__port, v.supply_ability AS v__supply_ability, v.packing AS v__packing, v.special_req AS v__special_req, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products v WHERE (v.brand = ? AND v.is_active = ?) ORDER BY v.updated_at DESC LIMIT 9 OFFSET 243 - (5, 1) |
12 | main | Call "pageHome->executeDepartment()" |
13 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE ((h.parent_id = ? OR h.parent_id is null) AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - () |
14 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (14) |
15 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (19) |
16 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (20) |
17 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (10) |
18 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (5) |
19 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (4) |
20 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (11) |
21 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (12) |
22 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (13) |
23 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (15) |
24 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (18) |
25 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (21) |
26 | sfPartialView | Render "sf_app_dir/modules/pageHome/templates/_department.php" |
27 | sfPartialView | Render "sf_app_dir/modules/pageProduct/templates/_listProduct.php" |
28 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
29 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
30 | main | Call "moduleMenu->executeMainMenu()" |
31 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE ((v.parent_id = ? OR v.parent_id is null) AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - () |
32 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (59) |
33 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (70) |
34 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (71) |
35 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (72) |
36 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (73) |
37 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (74) |
38 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (75) |
39 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (97) |
40 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (108) |
41 | Doctrine_Connection_Mysql | query : SELECT a.id AS a__id, a.name AS a__name, a.description AS a__description, a.content AS a__content, a.image_path AS a__image_path, a.is_active AS a__is_active, a.is_hot AS a__is_hot, a.lang AS a__lang, a.category_id AS a__category_id, a.slug AS a__slug, a.meta_keyword AS a__meta_keyword, a.meta_description AS a__meta_description, a.price AS a__price, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM ad_product a ORDER BY a.category_id DESC LIMIT 10 - () |
42 | sfPartialView | Render "sf_app_dir/modules/moduleMenu/templates/_mainMenu.php" |
43 | main | Call "moduleMenu->executeContentFooter()" |
44 | sfPartialView | Render "sf_app_dir/modules/moduleMenu/templates/_contentFooter.php" |
45 | main | Call "pageProduct->executeInquiryNowForm()" |
46 | sfPartialView | Render "sf_app_dir/modules/pageProduct/templates/_inquiryNowForm.php" |
47 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
48 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 18 | 3.29 | 1 |
Factories | 1 | 32.57 | 15 |
Action "pageProduct/brand" | 1 | 36.71 | 17 |
Database (Doctrine) | 28 | 13.95 | 6 |
View "Success" for "pageProduct/brand" | 1 | 83.70 | 39 |
Component "pageHome/department" | 1 | 18.76 | 8 |
Partial "pageHome/_department" | 1 | 2.08 | 0 |
Partial "pageProduct/_listProduct" | 1 | 3.51 | 1 |
Component "moduleMenu/mainMenu" | 1 | 26.68 | 12 |
Partial "moduleMenu/_mainMenu" | 1 | 2.25 | 1 |
Component "moduleMenu/contentFooter" | 1 | 0.01 | 0 |
Partial "moduleMenu/_contentFooter" | 1 | 0.43 | 0 |
Component "pageProduct/inquiryNowForm" | 1 | 9.98 | 4 |
Partial "pageProduct/_inquiryNowForm" | 1 | 2.24 | 1 |
SET NAMES 'UTF8'
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.slug = 'rattan-products')
SELECT COUNT(*) AS num_results FROM vtp_products v WHERE v.brand = '5' AND v.is_active = '1'
SELECT v.id AS v__id, v.product_name AS v__product_name, v.product_code AS v__product_code, v.category_id AS v__category_id, v.price AS v__price, v.price_promotion AS v__price_promotion, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.description AS v__description, v.content AS v__content, v.comment AS v__comment, v.warranty_information AS v__warranty_information, v.manufacturer AS v__manufacturer, v.accessories AS v__accessories, v.is_active AS v__is_active, v.is_home AS v__is_home, v.is_hot AS v__is_hot, v.slug AS v__slug, v.portal_id AS v__portal_id, v.lang AS v__lang, v.meta AS v__meta, v.keywords AS v__keywords, v.brand AS v__brand, v.reference_price AS v__reference_price, v.unit AS v__unit, v.origin AS v__origin, v.payment AS v__payment, v.delivery AS v__delivery, v.port AS v__port, v.supply_ability AS v__supply_ability, v.packing AS v__packing, v.special_req AS v__special_req, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products v WHERE (v.brand = '5' AND v.is_active = '1') ORDER BY v.updated_at DESC LIMIT 9 OFFSET 243
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE ((h.parent_id = '' OR h.parent_id is null) AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '14' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '19' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '20' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '10' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '5' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '4' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '11' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '12' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '13' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '15' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '18' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = '21' AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE ((v.parent_id = '' OR v.parent_id is null) AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '59' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '70' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '71' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '72' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '73' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '74' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '75' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '97' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = '108' AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50
SELECT a.id AS a__id, a.name AS a__name, a.description AS a__description, a.content AS a__content, a.image_path AS a__image_path, a.is_active AS a__is_active, a.is_hot AS a__is_hot, a.lang AS a__lang, a.category_id AS a__category_id, a.slug AS a__slug, a.meta_keyword AS a__meta_keyword, a.meta_description AS a__meta_description, a.price AS a__price, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM ad_product a ORDER BY a.category_id DESC LIMIT 10