Notice: Use of undefined constant fasle - assumed 'fasle' in /var/www/vhosts/dealgate.com/private/lib/model/doctrine/base/BaseD_AdvisorProfile.class.php on line 486 DEALGATE | The global platform for M&A professionals

Ausgeschaltetes JavaScript Warnung

Sie haben bei Ihrem Browser, bewusst oder unbewusst, JavaScript ausgeschaltet.

JavaScript ist eine Technologie, ohne die heutige, moderne Websites nicht mehr realisierbar sind.

Auch diese Website verwendet JavaScript.
Wenn Sie den vollen Funktionalitätsumfang dieser Website geniessen möchten, bitten wir Sie darum, JavaScript bei Ihrem Browser wieder zu aktivieren.

Home
Login


Username or E-Mail*
Password*
Keep me logged in

Find highly qualified advisors all over the world

Search for advisors by combining the search criteria below

Company*
Offices*
Services	Selectable services Selected services

Featured advisors

All advisors

Company

Services

Offices

Contact

Products & Services

M&A Opportunities

M&A News
Research Library

Partners

Register / Login

1.4.20
config
view
logs
14592.0 KB
926 ms
7

Configuration

debug
xdebug
logging
cache
compression
tokenizer
eaccelerator
apc
xcache

Request

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, rss: application/rss+xml }
  no_script_name: false
parameterHolder:
  action: index
  module: directory
  sf_culture: en
attributeHolder:
  sf_route: 'sfRoute Object()'

Response

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_min: {  }
  secure: {  }
  jquery_migrate: {  }
  jquery_equalHeights.js: {  }
  multiselect.min.js: {  }
  jquery_carousel.min.js: {  }
  headerbanner.js: {  }
  jquery.dataTables.js: {  }
  moment.min.js: {  }
  datetime-moment.js: {  }
  common.js: {  }
  jqcloud.min.js: {  }
  directory_filter.js: {  }
stylesheets:
  main.css: { media: screen }
  print.css: { media: print }
  jquery.dataTables.css: { media: screen }
  font-awesome.min.css: { media: screen }
  jqcloud.min.css: { media: screen }
  jquery.awesomeCloud-0.2.min.js: { media: screen }
metas:
  title: 'DEALGATE | The global platform for M&amp;A professionals'
  description: 'DEALGATE | The global platform for M&amp;A professionals'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

User

options:
  auto_shutdown: false
  culture: en
  default_culture: en
  use_flash: true
  logging: '1'
  timeout: 1800
attributeHolder: {  }
culture: en
authenticated: false
credentials: {  }
lastRequest: 1713513411

Settings

app_anonyme_ablehnung_anzahl: 14
app_anonyme_ablehnung_zeitraum: d
app_application: portal
app_bol_credit_card_payment: true
app_bol_debug: false
app_bol_debug_step_1: false
app_bol_debug_step_2: false
app_bol_multi_language: false
app_bounce_back_email_address: bounceback@dealgate.com
app_credit_card_environment: prod
app_customercare_email_address_from: customercare@dealgate.com
app_customercare_email_address_to_cc: sales@dealgate.com
app_deactivate_opp_on_membership_change: false
app_dealgate_info_email_address_to: beat.dolder@dealgate.com
app_default_lang: en
app_dev_key: ec3d25d7ad7f6c29c9bfd73dec4d2399e0d3b3635bd6c7fbce7aab9ccb51ab41edb01c0a31d9c03e3b955e3e542e4136e4054668e1314b087e738eca29786989
app_dev_key_ajax: 3d64f6e1582d046bca58fd8e8e45b5e4703879b05bb73e8ef13a93c30612a83b965ec6964625c9350f112dc843764f08af2741b7a9f464e0f5f7f76b6c95e810
app_dev_key_hd: ec3d25d7ad7f6c29c9bfd73dec4d2399e0d3b3635bd6c7fbce7aab9ccb51ab41edb01c0a31d9c03e3b955e3e542e4136e4054668e1314b087e738eca29786989
app_dev_key_recurring: 3edcf17192409c3e19926242809078970d2d84c5d9b96df23a8b5425a29c342a463070fa724f77f9876be24b03b746da1067f3f1def1cf1899401c16a7c7487f
app_dev_merchant_id: 1100003074
app_dev_merchant_id_recurring: 1100003179
app_dev_sign: 130307135858433673
app_dev_url_authorize_split: 'https://pilot.datatrans.biz/upp/jsp/XML_authorizeSplitEx.jsp'
app_dev_url_include_js: 'https://pilot.datatrans.biz/upp/ajax/api.js?merchantId='
app_dev_url_recurring_billing: 'https://pilot.datatrans.biz/upp/jsp/XML_authorize.jsp'
app_dev_url_settlement: 'https://pilot.datatrans.biz/upp/jsp/XML_processor.jsp'
app_ebitda_multiplier: 1000000
app_email_confirm_anzahl: 14
app_email_confirm_zeitraum: d
app_finance_email_address_to: finance@dealgate.com
app_host: www.dealgate.com
app_humandigital_error_email_address_to: team@humandigital.ch
app_humandigital_info_email_address_to: dealgate.blind@humandigital.ch
app_join_via_recom_anzahl: 2
app_join_via_recom_zeitraum: m
app_library_document_anzahl: 2
app_library_document_zeitraum: Y
app_linked_in_api_key_dev: 750o55ugyq8u7c
app_linked_in_api_key_prod: 759na4py2u0qo6
app_mailservice_email_address_from: mailservice@dealgate.com
app_mailservice_email_address_from_reminder: customercare@dealgate.ch
app_mailservice_email_address_to: beat.dolder@dealgate.com
app_max_dauer_mitgliedschaft_monate: 18
app_max_suchtreffer_per_page: 100
app_max_suchtreffer_per_page_iframe: 1000
app_membership_mm_anzahl: 1
app_membership_mm_zeitraum: Y
app_my_profile_anzahl: 3
app_my_profile_zeitraum: m
app_no_reply_email_address_from: no-reply@dealgate.com
app_opportunities_email_address_from: opportunities@dealgate.com
app_opportunity_ansehen_anzahl: 1
app_opportunity_ansehen_zeitraum: Y
app_opps_dont_deactivate_until: 1435701599
app_portal_default_billing_currency: 3
app_prod_key: aa3b868bc7daf7fb9fc3066b7c816ebf48a62f88820b9699eaed58cc7ece2a35121d9e78d7338252e5ce14bac0cd9e77558bf80460852067a50ff55266082384
app_prod_key_recurring: 50e1bcb4b7d9ad239268672498926c1ecb2a9bdf62a610ac0228b75e4c4b213b91d7e86b8d688cb570bec8cb5ed88c6d27498e04e057d22515f314ddbdc411cd
app_prod_merchant_id: 3000006607
app_prod_merchant_id_recurring: 3000006666
app_prod_url_authorize_split: 'https://payment.datatrans.biz/upp/jsp/XML_authorizeSplitEx.jsp'
app_prod_url_include_js: 'https://payment.datatrans.biz/upp/ajax/api.js?merchantId='
app_prod_url_recurring_billing: 'https://payment.datatrans.biz/upp/jsp/XML_authorize.jsp'
app_prod_url_settlement: 'https://payment.datatrans.biz/upp/jsp/XML_processor.jsp'
app_protocol: https
app_recommendation_email_address_from: recommendations@dealgate.com
app_recommendation_reward_extension: 1
app_recommendation_reward_tokens: 5
app_register_check_required: true
app_register_for_free_until: 1325372399
app_reminder_mm_anzahl: 15
app_reminder_mm_zeitraum: d
app_sales_email_address_from: sales@dealgate.com
app_sf_guard_plugin_change_password_form: sfGuardFormChangeUserPasswordDealgate
app_sf_guard_plugin_default_from_email: mailservice@dealgate.com
app_sf_guard_plugin_forgot_password_form: sfGuardFormForgotPasswordDealgate
app_sf_guard_plugin_remember_cookie_name: sfRemember
app_sf_guard_plugin_signin_form: sfGuardFormSigninDealgate
app_sf_guard_plugin_success_signin_url: '@suche'
app_sf_guard_plugin_success_signout_url: localized_homepage
app_special_offer_until: 1335805200
app_teasers_email_address_from: teasers@dealgate.com
app_welcome_tokens: 3
mod__navigation_enabled: true
mod__navigation_view_class: sfPHP
mod_directory_enabled: true
mod_directory_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: portal
sf_app_base_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal
sf_app_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev
sf_app_config_dir: /var/www/vhosts/dealgate.com/private/apps/portal/config
sf_app_dir: /var/www/vhosts/dealgate.com/private/apps/portal
sf_app_i18n_dir: /var/www/vhosts/dealgate.com/private/apps/portal/i18n
sf_app_lib_dir: /var/www/vhosts/dealgate.com/private/apps/portal/lib
sf_app_module_dir: /var/www/vhosts/dealgate.com/private/apps/portal/modules
sf_app_template_dir: /var/www/vhosts/dealgate.com/private/apps/portal/templates
sf_apps_dir: /var/www/vhosts/dealgate.com/private/apps
sf_cache: false
sf_cache_dir: /var/www/vhosts/dealgate.com/private/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/config
sf_config_dir: /var/www/vhosts/dealgate.com/private/config
sf_csrf_secret: false
sf_data_dir: /var/www/vhosts/dealgate.com/private/data
sf_debug: true
sf_default_culture: en
sf_enabled_modules:
  - default
  - sfGuardAuth
  - sfGuardForgotPassword
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_500_action: error500
sf_error_500_module: default
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: /var/www/vhosts/dealgate.com/private/cache/portal/dev/i18n
sf_lib_dir: /var/www/vhosts/dealgate.com/private/lib
sf_log_dir: /var/www/vhosts/dealgate.com/private/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: __login
sf_module_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /var/www/vhosts/dealgate.com/private/plugins
sf_root_dir: /var/www/vhosts/dealgate.com/private
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
sf_symfony_lib_dir: /var/www/vhosts/dealgate.com/private/lib/vendor/symfony/lib
sf_template_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/template
sf_test_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/test
sf_test_dir: /var/www/vhosts/dealgate.com/private/test
sf_upload_dir: /var/www/vhosts/dealgate.com/httpdocs/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/vhosts/dealgate.com/httpdocs
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true

Globals

cookie: {  }
env: {  }
files: {  }
get: {  }
post: {  }
server:
  CONTEXT_DOCUMENT_ROOT: /var/www/vhosts/dealgate.com/httpdocs
  CONTEXT_PREFIX: ''
  DOCUMENT_ROOT: /var/www/vhosts/dealgate.com/httpdocs
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /var/www/vhosts/dealgate.com
  HTTPS: on
  HTTP_ACCEPT: '*/*'
  HTTP_HOST: www.dealgate.com
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
  PATH_INFO: /en/directory
  PATH_TRANSLATED: 'redirect:/index.php/directory'
  PERL5LIB: '/usr/share/awstats/lib:/usr/share/awstats/plugins'
  PHP_SELF: /portal_dev.php/en/directory
  QUERY_STRING: ''
  REMOTE_ADDR: 3.144.28.50
  REMOTE_PORT: '33704'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1713513411
  REQUEST_TIME_FLOAT: 1713513411.3992
  REQUEST_URI: /portal_dev.php/en/directory
  SCRIPT_FILENAME: /var/www/vhosts/dealgate.com/httpdocs/portal_dev.php
  SCRIPT_NAME: /portal_dev.php
  SERVER_ADDR: 46.231.204.150
  SERVER_ADMIN: root@localhost
  SERVER_NAME: www.dealgate.com
  SERVER_PORT: '443'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
  SSL_TLS_SNI: www.dealgate.com
  UNIQUE_ID: ZiIjwx-RkDF2GX-yTwdn7AAAAAQ
  USER: dealgate1
  proxy-nokeepalive: '1'
session: {  }

Php

php: 5.6.40
os: 'Linux mc17n0902.dnh.net 3.10.0-1160.114.2.el7.x86_64 #1 SMP Wed Mar 20 15:54:52 UTC 2024 x86_64'
extensions:
  14: bcmath
  15: bz2
  16: calendar
  13: cgi-fcgi
  0: 'Core (5.6.40)'
  17: ctype
  18: curl
  1: 'date (5.6.40)'
  19: dba
  20: 'dom (20031129)'
  2: ereg
  29: 'exif (1.4 $Id: cad29b729548e4206f0697710cc9e177f26fdff3 $)'
  22: 'fileinfo (1.0.5)'
  7: 'filter (0.11.0)'
  23: ftp
  24: gd
  25: gettext
  8: 'hash (1.0)'
  26: iconv
  58: 'imagick (3.7.0)'
  27: imap
  28: 'intl (1.1.0)'
  61: 'ionCube Loader (13.0.2)'
  59: 'json (1.3.10)'
  3: libxml
  21: mbstring
  30: mcrypt
  60: mhash
  49: 'mysql (1.0)'
  50: 'mysqli (0.1)'
  31: 'mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $)'
  32: 'odbc (1.0)'
  4: openssl
  5: pcre
  33: 'PDO (1.0.4dev)'
  51: 'pdo_mysql (1.0.2)'
  52: 'PDO_ODBC (1.0.1)'
  53: 'pdo_sqlite (1.0.1)'
  34: 'Phar (2.0.2)'
  35: posix
  36: pspell
  9: 'Reflection ($Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $)'
  11: session
  37: shmop
  38: 'SimpleXML (0.1)'
  39: soap
  40: sockets
  10: 'SPL (0.2)'
  41: 'sqlite3 (0.7-dev)'
  12: 'standard (5.6.40)'
  42: sysvmsg
  43: sysvsem
  44: sysvshm
  45: 'tokenizer (0.1)'
  54: wddx
  46: xml
  55: 'xmlreader (0.1)'
  56: 'xmlrpc (0.51)'
  47: 'xmlwriter (0.1)'
  48: 'xsl (0.1)'
  63: 'Zend Guard Loader'
  62: 'Zend OPcache (7.0.6-devFE)'
  57: 'zip (1.22.3)'
  6: 'zlib (2.0)'

Symfony

version: 1.4.20
path: /var/www/vhosts/dealgate.com/private/lib/vendor/symfony/lib

View Layer

Template: directory … indexSuccess.php

Parameters:

$param_language (string)
$formFilterAdvisor (D_AdvisorProfileFormFilter)
- $formFilterAdvisor['user_id'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['creator_id'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['firstname'] (sfWidgetFormFilterInput)
- $formFilterAdvisor['lastname'] (sfWidgetFormFilterInput)
- $formFilterAdvisor['company'] (sfWidgetFormFilterInput)
- $formFilterAdvisor['email'] (sfWidgetFormFilterInput)
- $formFilterAdvisor['website'] (sfWidgetFormFilterInput)
- $formFilterAdvisor['logo'] (sfWidgetFormFilterInput)
- $formFilterAdvisor['geo_1_code'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['geo_2_code'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['geo_3_code'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['geo_4_code'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['geo_5_code'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['geo_6_code'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['advisor_type'] (sfWidgetFormFilterInput)
- $formFilterAdvisor['currency_id'] (sfWidgetFormDoctrineChoice)
- $formFilterAdvisor['is_active'] (sfWidgetFormFilterInput)
- $formFilterAdvisor['created_at'] (sfWidgetFormFilterDate)
- $formFilterAdvisor['updated_at'] (sfWidgetFormFilterDate)
- $formFilterAdvisor['geo_code'] (sfWidgetFormInputHidden)
- $formFilterAdvisor['services'] (sfWidgetFormChoice)
$geolocations (array)
$allservices (array)
$featuredadvisors (Doctrine_Collection)
$alladvisors (Doctrine_Collection)

Partial: default … _header_banner.php

Partial: directory … _form_advisorfilter_tbody.php

Partial: directory … _featured_advisors.php

Partial: directory … _all_advisors.php

Partial: _navigation … _navigation_top.php

Partial: _navigation … _navigation_main.php

Partial: __login … _form_signin.php

Partial: __login … _form_signin_body.php

Partial: default … _footer.php

Partial: _navigation … _navigation_footer.php

Partial: _navigation … _navigation_footer_account.php

Logs

#	type	message
1	sfPatternRouting	Connect sfRoute "sf_guard_signin" (/guard/login)
2	sfPatternRouting	Connect sfRoute "sf_guard_signout" (/guard/logout)
3	sfPatternRouting	Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
4	sfPatternRouting	Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
5	sfPatternRouting	Match route "directory" (/:sf_culture/directory) for /en/directory with parameters array ( 'module' => 'directory', 'action' => 'index', 'sf_culture' => 'en',)
6	sfFilterChain	Executing filter "sfRenderingFilter"
7	sfFilterChain	Executing filter "sfGuardRememberMeFilter"
8	sfFilterChain	Executing filter "sfExecutionFilter"
9	directoryActions	Call "directoryActions->executeIndex()"
10	Doctrine_Connection_Mysql	exec : SET NAMES 'UTF8' - ()
11	Doctrine_Connection_Statement	execute : SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.service AS d2__service FROM d__company_service d LEFT JOIN d__company_service_translation d2 ON d.id = d2.id WHERE (d2.lang = ?) ORDER BY d.sort_id ASC - (en)
12	Doctrine_Connection_Statement	execute : SELECT i.code AS i__code, i.parent_code AS i__parent_code, i2.code AS i2__code, i2.lang AS i2__lang, i2.geo AS i2__geo FROM i__geo i LEFT JOIN i__geo_translation i2 ON i.code = i2.code WHERE (i2.lang = ?) - (en)
13	Doctrine_Connection_Statement	execute : SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.service AS d2__service FROM d__company_service d LEFT JOIN d__company_service_translation d2 ON d.id = d2.id WHERE (d2.lang = ?) - (en)
14	Doctrine_Connection_Statement	execute : SELECT d.id AS d__id, d.user_id AS d__user_id, d.creator_id AS d__creator_id, d.firstname AS d__firstname, d.lastname AS d__lastname, d.company AS d__company, d.email AS d__email, d.website AS d__website, d.logo AS d__logo, d.geo_1_code AS d__geo_1_code, d.geo_2_code AS d__geo_2_code, d.geo_3_code AS d__geo_3_code, d.geo_4_code AS d__geo_4_code, d.geo_5_code AS d__geo_5_code, d.geo_6_code AS d__geo_6_code, d.about_us AS d__about_us, d.advisor_type AS d__advisor_type, d.currency_id AS d__currency_id, d.is_active AS d__is_active, d.created_at AS d__created_at, d.updated_at AS d__updated_at, d.bol_renew_mbship AS d__bol_renew_mbship, d.expm AS d__expm, d.expy AS d__expy, d.alias_cc AS d__alias_cc, d.masked_cc AS d__masked_cc, d.agb_gelesen_datum AS d__agb_gelesen_datum, d.bol_agb_gelesen AS d__bol_agb_gelesen, d.agb_id AS d__agb_id, d.bol_cc_valide AS d__bol_cc_valide, d.last_try_date AS d__last_try_date, d.last_paid_on AS d__last_paid_on, d.payment_expiry AS d__payment_expiry, d.mail_status AS d__mail_status, d.mail_status_date AS d__mail_status_date, d.phone AS d__phone, GROUP_CONCAT(d2.company_service_id) AS d2__0 FROM d__advisor_profile d LEFT JOIN d__advisor_profile_service d2 ON d.id = d2.advisor_profile_id WHERE (date(d.payment_expiry) > ? AND d.payment_expiry IS NOT NULL AND d.is_active = ? AND d.advisor_type = ?) GROUP BY d.id ORDER BY d.company - (2024-04-19, 1, F)
15	Doctrine_Connection_Statement	execute : SELECT d.id AS d__id, d.user_id AS d__user_id, d.creator_id AS d__creator_id, d.firstname AS d__firstname, d.lastname AS d__lastname, d.company AS d__company, d.email AS d__email, d.website AS d__website, d.logo AS d__logo, d.geo_1_code AS d__geo_1_code, d.geo_2_code AS d__geo_2_code, d.geo_3_code AS d__geo_3_code, d.geo_4_code AS d__geo_4_code, d.geo_5_code AS d__geo_5_code, d.geo_6_code AS d__geo_6_code, d.about_us AS d__about_us, d.advisor_type AS d__advisor_type, d.currency_id AS d__currency_id, d.is_active AS d__is_active, d.created_at AS d__created_at, d.updated_at AS d__updated_at, d.bol_renew_mbship AS d__bol_renew_mbship, d.expm AS d__expm, d.expy AS d__expy, d.alias_cc AS d__alias_cc, d.masked_cc AS d__masked_cc, d.agb_gelesen_datum AS d__agb_gelesen_datum, d.bol_agb_gelesen AS d__bol_agb_gelesen, d.agb_id AS d__agb_id, d.bol_cc_valide AS d__bol_cc_valide, d.last_try_date AS d__last_try_date, d.last_paid_on AS d__last_paid_on, d.payment_expiry AS d__payment_expiry, d.mail_status AS d__mail_status, d.mail_status_date AS d__mail_status_date, d.phone AS d__phone, GROUP_CONCAT(d2.company_service_id) AS d2__0 FROM d__advisor_profile d LEFT JOIN d__advisor_profile_service d2 ON d.id = d2.advisor_profile_id WHERE (date(d.payment_expiry) > ? AND d.payment_expiry IS NOT NULL AND d.is_active = ?) GROUP BY d.id ORDER BY d.company - (2024-04-19, 1)
16	sfPHPView	Render "sf_app_dir/modules/directory/templates/indexSuccess.php"
17	sfPartialView	Render "sf_app_dir/modules/default/templates/_header_banner.php"
18	sfPartialView	Render "sf_app_dir/modules/directory/templates/_form_advisorfilter_tbody.php"
19	sfPartialView	Render "sf_app_dir/modules/directory/templates/_featured_advisors.php"
20	sfPartialView	Render "sf_app_dir/modules/directory/templates/_all_advisors.php"
21	sfPHPView	Decorate content with "sf_app_dir/templates/layout.php"
22	sfPHPView	Render "sf_app_dir/templates/layout.php"
23	main	Call "_navigation->executeNavigation_top()"
24	sfPartialView	Render "sf_app_dir/modules/_navigation/templates/_navigation_top.php"
25	main	Call "_navigation->executeNavigation_main()"
26	sfPartialView	Render "sf_app_dir/modules/_navigation/templates/_navigation_main.php"
27	sfPartialView	Render "sf_app_dir/modules/__login/templates/_form_signin.php"
28	sfPartialView	Render "sf_app_dir/modules/__login/templates/_form_signin_body.php"
29	sfPartialView	Render "sf_app_dir/modules/default/templates/_footer.php"
30	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.dateiname AS a__dateiname FROM a__a_g_b_verwaltung a WHERE (ISNULL(gueltig_bis) OR a.gueltig_bis > ?) - (2024-04-19)
31	main	Call "_navigation->executeNavigation_footer()"
32	sfPartialView	Render "sf_app_dir/modules/_navigation/templates/_navigation_footer.php"
33	main	Call "_navigation->executeNavigation_footer_account()"
34	sfPartialView	Render "sf_app_dir/modules/_navigation/templates/_navigation_footer_account.php"
35	sfWebResponse	Send status "HTTP/1.1 200 OK"
36	sfWebResponse	Send header "Content-Type: text/html; charset=utf-8"

type	calls	time (ms)	time (%)
Configuration	19	538.31	58
Factories	1	56.35	6
Action "directory/index"	1	670.82	72
Database (Doctrine)	7	8.65	0
View "Success" for "directory/index"	1	119.20	12
Partial "default/_header_banner"	1	1.12	0
Partial "directory/_form_advisorfilter_tbody"	1	11.22	1
Partial "directory/_featured_advisors"	1	0.85	0
Partial "directory/_all_advisors"	1	0.80	0
Component "_navigation/navigation_top"	1	0.04	0
Partial "_navigation/_navigation_top"	1	7.46	0
Component "_navigation/navigation_main"	1	1.04	0
Partial "_navigation/_navigation_main"	1	1.97	0
Partial "__login/_form_signin"	1	9.03	0
Partial "__login/_form_signin_body"	1	7.94	0
Partial "default/_footer"	1	25.00	2
Component "_navigation/navigation_footer"	1	0.10	0
Partial "_navigation/_navigation_footer"	1	1.42	0
Component "_navigation/navigation_footer_account"	1	0.07	0
Partial "_navigation/_navigation_footer_account"	1	0.89	0

SQL queries

Doctrine Version: 1.2.4

SET NAMES 'UTF8'

0.00s, "doctrine" connection
SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.service AS d2__service FROM d__company_service d LEFT JOIN d__company_service_translation d2 ON d.id = d2.id WHERE (d2.lang = 'en') ORDER BY d.sort_id ASC

0.00s, "doctrine" connection
SELECT i.code AS i__code, i.parent_code AS i__parent_code, i2.code AS i2__code, i2.lang AS i2__lang, i2.geo AS i2__geo FROM i__geo i LEFT JOIN i__geo_translation i2 ON i.code = i2.code WHERE (i2.lang = 'en')

0.00s, "doctrine" connection
SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.service AS d2__service FROM d__company_service d LEFT JOIN d__company_service_translation d2 ON d.id = d2.id WHERE (d2.lang = 'en')

0.00s, "doctrine" connection
SELECT d.id AS d__id, d.user_id AS d__user_id, d.creator_id AS d__creator_id, d.firstname AS d__firstname, d.lastname AS d__lastname, d.company AS d__company, d.email AS d__email, d.website AS d__website, d.logo AS d__logo, d.geo_1_code AS d__geo_1_code, d.geo_2_code AS d__geo_2_code, d.geo_3_code AS d__geo_3_code, d.geo_4_code AS d__geo_4_code, d.geo_5_code AS d__geo_5_code, d.geo_6_code AS d__geo_6_code, d.about_us AS d__about_us, d.advisor_type AS d__advisor_type, d.currency_id AS d__currency_id, d.is_active AS d__is_active, d.created_at AS d__created_at, d.updated_at AS d__updated_at, d.bol_renew_mbship AS d__bol_renew_mbship, d.expm AS d__expm, d.expy AS d__expy, d.alias_cc AS d__alias_cc, d.masked_cc AS d__masked_cc, d.agb_gelesen_datum AS d__agb_gelesen_datum, d.bol_agb_gelesen AS d__bol_agb_gelesen, d.agb_id AS d__agb_id, d.bol_cc_valide AS d__bol_cc_valide, d.last_try_date AS d__last_try_date, d.last_paid_on AS d__last_paid_on, d.payment_expiry AS d__payment_expiry, d.mail_status AS d__mail_status, d.mail_status_date AS d__mail_status_date, d.phone AS d__phone, GROUP_CONCAT(d2.company_service_id) AS d2__0 FROM d__advisor_profile d LEFT JOIN d__advisor_profile_service d2 ON d.id = d2.advisor_profile_id WHERE (date(d.payment_expiry) > '2024-04-19' AND d.payment_expiry IS NOT NULL AND d.is_active = '1' AND d.advisor_type = 'F') GROUP BY d.id ORDER BY d.company

0.00s, "doctrine" connection
SELECT d.id AS d__id, d.user_id AS d__user_id, d.creator_id AS d__creator_id, d.firstname AS d__firstname, d.lastname AS d__lastname, d.company AS d__company, d.email AS d__email, d.website AS d__website, d.logo AS d__logo, d.geo_1_code AS d__geo_1_code, d.geo_2_code AS d__geo_2_code, d.geo_3_code AS d__geo_3_code, d.geo_4_code AS d__geo_4_code, d.geo_5_code AS d__geo_5_code, d.geo_6_code AS d__geo_6_code, d.about_us AS d__about_us, d.advisor_type AS d__advisor_type, d.currency_id AS d__currency_id, d.is_active AS d__is_active, d.created_at AS d__created_at, d.updated_at AS d__updated_at, d.bol_renew_mbship AS d__bol_renew_mbship, d.expm AS d__expm, d.expy AS d__expy, d.alias_cc AS d__alias_cc, d.masked_cc AS d__masked_cc, d.agb_gelesen_datum AS d__agb_gelesen_datum, d.bol_agb_gelesen AS d__bol_agb_gelesen, d.agb_id AS d__agb_id, d.bol_cc_valide AS d__bol_cc_valide, d.last_try_date AS d__last_try_date, d.last_paid_on AS d__last_paid_on, d.payment_expiry AS d__payment_expiry, d.mail_status AS d__mail_status, d.mail_status_date AS d__mail_status_date, d.phone AS d__phone, GROUP_CONCAT(d2.company_service_id) AS d2__0 FROM d__advisor_profile d LEFT JOIN d__advisor_profile_service d2 ON d.id = d2.advisor_profile_id WHERE (date(d.payment_expiry) > '2024-04-19' AND d.payment_expiry IS NOT NULL AND d.is_active = '1') GROUP BY d.id ORDER BY d.company

0.00s, "doctrine" connection
SELECT a.id AS a__id, a.dateiname AS a__dateiname FROM a__a_g_b_verwaltung a WHERE (ISNULL(gueltig_bis) OR a.gueltig_bis > '2024-04-19')

0.00s, "doctrine" connection