Venez vivre une expérience unique! Le réseau de la santé et des services sociaux du Nunavik comprend la Régie régionale de la santé et des services sociaux Nunavik, le Centre de santé Inuulitsivik (côte d’Hudson) et le Centre de santé Tulattavik de l’Ungava (c&oc Lire la suite...
config
view
logs
49664.0 KB
7044 ms
32
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: list
f: { profile: '6' }
module: employeurs
page: '7'
sf_culture: fr
website_id: '1'
website_short_code: sante
attributeHolder:
sf_route: 'websiteRoute 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:
//ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js: { }
//ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/jquery-ui.min.js: { }
'//maps.googleapis.com/maps/api/js?key=AIzaSyDGSEIC64xCNJByLWzWaLutGBfHrLr3poo&libraries=places&sensor=true': { }
ckeditor/ckeditor: { }
/sfCkPlugin/js/sfCkPlugin.js: { }
jquery.youtubeplaylist.js: { }
jquery.easing.1.3.js: { }
slides.min.jquery.js: { }
jquery.bxSlider.min.js: { }
colorbox/jquery.colorbox-min.js: { }
'scripts.js?v=2': { }
bootstrap-tooltip.js: { }
jquery.maskedinput.js: { }
jquery.playSound.js: { }
jquery.cycle2.min.js: { }
stylesheets:
bootstrap.min.css: { }
'main.css?v=6': { }
/js/colorbox/colorbox.css: { }
//ajax.googleapis.com/ajax/libs/jqueryui/1.9.0/themes/base/jquery-ui.css: { }
metas:
description: 'Emploi en santé - Premier site Web spécialisé d’emplois en santé au Québec! Un emploi sur mesure à votre portée! Change ton style de vie! - Page 7'
keywords: 'Emploi en santé'
title: 'Emploi en santé - Premier site d’emplois en santé au Québec! - Page 7'
language: fr
httpMetas:
Content-Type: 'text/html; charset=utf-8'
options:
auto_shutdown: false
culture: fr
default_culture: fr_FR
use_flash: true
logging: '1'
timeout: 86400
attributeHolder:
symfony/user/sfUser/attributes: { last_companies_filters: { f: { profile: '6', s: '', l: '', lll: '', sector: null, province: null, region: null } }, website_id: '1', website_short_code: sante }
culture: fr
authenticated: false
credentials: { }
lastRequest: 1746252577
app_country_setup: ca
app_facebook_app_id: 241749253051494
app_facebook_app_secret: 6de6bf5662b14ff2739c4985102fa9d7
app_mp_reality_admin_categories:
Bloc1: { label: Moderation, class: medium, items: { Articles: { url: jobeet_job, image: email.png, badge: { model: JobeetJob, table_method: getActiveJobs }, credentials: [[admin, publisher]] }, Comments: { url: product, image: basket.png, badge: { model: Product, table_method: findAll }, credentials: [admin] } } }
Bloc2: { label: Activity, class: medium, items: { Articles1: { url: product_test2, image: coins.png, credentials: [[admin, publisher]] }, Comments1: { url: jobeet_category, image: user.png, credentials: [admin] } } }
Bloc3: { label: 'Console 3', class: medium, items: { Articles1: { url: product_test2, image: coins.png, credentials: [[admin, publisher]] }, Comments2: { url: jobeet_category, image: user.png, credentials: [admin] } } }
app_mp_reality_admin_css_reset: false
app_mp_reality_admin_image_dir: /mpRealityAdminPlugin/images/icondock/
app_mp_reality_admin_max_per_page:
- '3'
- '5'
- '10'
- '20'
- '50'
- '100'
- ∞
app_mp_reality_admin_site_tile: mpRealityAdminPlugin
app_mp_reality_admin_use_jquery: true
app_mp_reality_admin_web_dir: /mpRealityAdminPlugin
app_sfImageTransformPlugin_default_adapter: GD
app_sfImageTransformPlugin_default_image:
mime_type: image/png
filename: Untitled.png
width: 100
height: 100
color: '#FFFFFF'
app_sfImageTransformPlugin_font_dir: /usr/share/fonts/truetype/msttcorefonts
app_sfImageTransformPlugin_mime_type:
auto_detect: true
library: gd_mime_type
app_sf_guard_plugin_profile_class: Profile
app_sf_guard_plugin_profile_field_name: user_id
app_sf_guard_plugin_remember_cookie_name: technocomm
app_sf_guard_plugin_remember_key_expiration_age: 25920000
mod_employeurs_enabled: true
mod_employeurs_view_class: sfPHP
mod_offres_enabled: true
mod_offres_view_class: sfPHP
mod_page_enabled: true
mod_page_view_class: sfPHP
mod_pub_enabled: true
mod_pub_view_class: sfPHP
sfTCPDFPlugin_dir: /var/www/symfony/dev/plugins/sfTCPDFPlugin/lib/tcpdf/
sfTCPDFPlugin_font_dir: /var/www/symfony/dev/plugins/sfTCPDFPlugin/lib/tcpdf/fonts/
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /var/www/symfony/dev/cache/frontend
sf_app_cache_dir: /var/www/symfony/dev/cache/frontend/dev
sf_app_config_dir: /var/www/symfony/dev/apps/frontend/config
sf_app_dir: /var/www/symfony/dev/apps/frontend
sf_app_i18n_dir: /var/www/symfony/dev/apps/frontend/i18n
sf_app_lib_dir: /var/www/symfony/dev/apps/frontend/lib
sf_app_module_dir: /var/www/symfony/dev/apps/frontend/modules
sf_app_template_dir: /var/www/symfony/dev/apps/frontend/templates
sf_apps_dir: /var/www/symfony/dev/apps
sf_cache: false
sf_cache_dir: /var/www/symfony/dev/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /var/www/symfony/dev/cache/frontend/dev/config
sf_config_dir: /var/www/symfony/dev/config
sf_csrf_secret: FrogSoft2012
sf_data_dir: /var/www/symfony/dev/data
sf_debug: true
sf_default_culture: fr_FR
sf_enabled_modules:
- default
- sfGuardAuth
- contact
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: page
sf_error_reporting: 32767
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: on
sf_i18n_cache_dir: /var/www/symfony/dev/cache/frontend/dev/i18n
sf_lib_dir: /var/www/symfony/dev/lib
sf_log_dir: /var/www/symfony/dev/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: sfGuardAuth
sf_module_cache_dir: /var/www/symfony/dev/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: /var/www/symfony/dev/plugins
sf_root_dir: /var/www/symfony/dev
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers:
- Partial
- Cache
- I18N
- Text
sf_symfony_lib_dir: /var/www/symfony/dev/lib/vendor/symfony/lib
sf_template_cache_dir: /var/www/symfony/dev/cache/frontend/dev/template
sf_test_cache_dir: /var/www/symfony/dev/cache/frontend/dev/test
sf_test_dir: /var/www/symfony/dev/test
sf_upload_dir: /var/www/symfony/dev/../../public_html/uploads
sf_upload_dir_name: uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/symfony/dev/../../public_html
sf_web_dir_name: public_html
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true
symfony.view.slot_names: { }
cookie: { }
env: { }
files: { }
get:
f: { profile: '6' }
page: '7'
post: { }
server:
CONTEXT_DOCUMENT_ROOT: /var/www/public_html/
CONTEXT_PREFIX: ''
DOCUMENT_ROOT: /var/www/public_html/
FCGI_ROLE: RESPONDER
GATEWAY_INTERFACE: CGI/1.1
HOME: /usr/share/httpd
HTTPS: on
HTTP_ACCEPT: '*/*'
HTTP_ACCEPT_ENCODING: 'gzip, br'
HTTP_CDN_LOOP: 'cloudflare; loops=1'
HTTP_CF_IPCOUNTRY: US
HTTP_CF_RAY: 939d97199d2a170f-ORD
HTTP_CF_VISITOR: '{"scheme":"https"}'
HTTP_HOST: www.emploisprofessionnelsensante.com
HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])'
HTTP_X_FORWARDED_FOR: 18.118.14.81
HTTP_X_FORWARDED_PROTO: https
PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
PATH_INFO: /fr/employeurs
PATH_TRANSLATED: 'redirect:/index.php/employeurs'
PHP_SELF: /frontend_dev.php/fr/employeurs
QUERY_STRING: 'f%5Bprofile%5D=6&page=7'
REMOTE_ADDR: 18.118.14.81
REMOTE_PORT: '20186'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1746252573
REQUEST_TIME_FLOAT: 1746252573.796
REQUEST_URI: '/frontend_dev.php/fr/employeurs?f%5Bprofile%5D=6&page=7'
SCRIPT_FILENAME: /var/www/public_html/frontend_dev.php
SCRIPT_NAME: /frontend_dev.php
SERVER_ADDR: 173.209.40.88
SERVER_ADMIN: [email protected]
SERVER_NAME: www.emploisprofessionnelsensante.com
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: ''
SERVER_SOFTWARE: 'Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/5.6.40'
SSL_TLS_SNI: www.emploisprofessionnelsensante.com
UNIQUE_ID: aBWzHdkshwQX8lNETdr9MwAAA8o
USER: apache
session:
KCFINDER: { disabled: true }
php: 5.6.40 os: 'Linux server.emploisprofessionnelsensante.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 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)' 21: 'enchant (1.1.0)' 2: ereg 32: 'exif (1.4 $Id: cad29b729548e4206f0697710cc9e177f26fdff3 $)' 23: 'fileinfo (1.0.5)' 7: 'filter (0.11.0)' 24: ftp 25: gd 26: gettext 27: gmp 8: 'hash (1.0)' 28: iconv 29: imap 30: 'intl (1.1.0)' 62: 'json (1.3.10)' 31: ldap 3: libxml 22: mbstring 33: mcrypt 63: mhash 54: 'mysql (1.0)' 55: 'mysqli (0.1)' 34: 'mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $)' 35: 'odbc (1.0)' 4: openssl 5: pcre 36: 'PDO (1.0.4dev)' 56: 'pdo_mysql (1.0.2)' 57: 'PDO_ODBC (1.0.1)' 58: 'pdo_sqlite (1.0.1)' 37: 'Phar (2.0.2)' 38: posix 39: pspell 9: 'Reflection ($Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $)' 11: session 40: shmop 41: 'SimpleXML (0.1)' 42: 'snmp (0.1)' 43: soap 44: sockets 10: 'SPL (0.2)' 45: 'sqlite3 (0.7-dev)' 12: 'standard (5.6.40)' 46: sysvmsg 47: sysvsem 48: sysvshm 49: 'tidy (2.0)' 50: 'tokenizer (0.1)' 59: wddx 51: xml 60: 'xmlreader (0.1)' 52: 'xmlwriter (0.1)' 53: 'xsl (0.1)' 61: 'zip (1.22.3)' 6: 'zlib (2.0)'
version: 1.4.17 path: /var/www/symfony/dev/lib/vendor/symfony/lib
Parameters:
$website (Website)$form (FilterCompaniesForm)
$form['s'] (sfWidgetFormInputText)
$form['l'] (sfWidgetFormInputText)
$form['lll'] (sfWidgetFormInputHidden)
$form['profile'] (sfWidgetFormDoctrineChoice)
$form['sector'] (sfWidgetFormDoctrineChoice)
$form['province'] (sfWidgetFormDoctrineChoice)
$form['region'] (sfWidgetFormDoctrineChoice)
$pager (sfDoctrinePager)Parameters:
$profile (CompanyProfile)$sector (NULL)$province (NULL)$region (NULL)$active_filters (array)Parameters:
$form (FilterCompaniesForm)
$form['s'] (sfWidgetFormInputText)
$form['l'] (sfWidgetFormInputText)
$form['lll'] (sfWidgetFormInputHidden)
$form['profile'] (sfWidgetFormDoctrineChoice)
$form['sector'] (sfWidgetFormDoctrineChoice)
$form['province'] (sfWidgetFormDoctrineChoice)
$form['region'] (sfWidgetFormDoctrineChoice)
$form_values (array)Parameters:
$company (Company)Parameters:
$website (Website)$title (string)Parameters:
$website (Website)Parameters:
$id (string)$pages (Doctrine_Collection)$include_ul (boolean)$include_li (boolean)$parent_id (NULL)Parameters:
$website (Website)Parameters:
$id (string)$pages (Doctrine_Collection)$include_ul (boolean)$include_li (boolean)$parent_id (NULL)Parameters:
$form (SearchOffersForm)
$form['s'] (sfWidgetFormInputText)
$form['l'] (sfWidgetFormInputText)
$form['lll'] (sfWidgetFormInputHidden)
Parameters:
$id (string)$pages (Doctrine_Collection)$include_ul (boolean)$include_li (boolean)$parent_id (NULL)Parameters:
$id (string)$pages (Doctrine_Collection)$include_ul (boolean)$include_li (boolean)$parent_id (NULL)Parameters:
$id (string)$pages (Doctrine_Collection)$include_ul (boolean)$include_li (boolean)$parent_id (NULL)Parameters:
$website (Website)$id_ga (string)
| # | type | message |
|---|---|---|
| 1 | sfPatternRouting | Connect sfRoute "sf_guard_signin" (/guard/login) |
| 2 | sfPatternRouting | Connect sfRoute "sf_guard_signout" (/guard/logout) |
| 3 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 4 | Doctrine_Connection_Mysql | query : SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')) - () |
| 5 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.domain = ?) LIMIT 1 - (emploisprofessionnelsensante.com) |
| 6 | sfPatternRouting | Match route "employeurs_liste" (/:sf_culture/employeurs) for /fr/employeurs with parameters array ( 'website_id' => '1', 'website_short_code' => 'sante', 'module' => 'employeurs', 'action' => 'list', 'sf_culture' => 'fr',) |
| 7 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 8 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 9 | employeursActions | Call "employeursActions->executeList()" |
| 10 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 11 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM company_profile c WHERE c.id = ? - (6) |
| 12 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM company c LEFT JOIN company_translation c2 ON c.id = c2.id LEFT JOIN company_portail c3 ON c.id = c3.company_id LEFT JOIN company_portail_translation c4 ON c3.id = c4.id WHERE c4.lang = ? AND c3.website_id = ? AND c.company_profile_id = ? GROUP BY c.id) dctrn_count_query - (fr, 1, 6) |
| 13 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.titre AS w__titre, w.video_employeur AS w__video_employeur, w.video_candidat AS w__video_candidat, w.meta_title AS w__meta_title, w.meta_description AS w__meta_description, w.meta_keywords AS w__meta_keywords, w.id_analytics AS w__id_analytics, w.titre_section_tendances AS w__titre_section_tendances, w.lang AS w__lang FROM website_translation w WHERE (w.id IN (?)) - (1) |
| 14 | sfPHPView | Render "sf_app_dir/modules/employeurs/templates/listSuccess.php" |
| 15 | main | Set slot "title" |
| 16 | main | Set slot "sidebar-left" |
| 17 | main | Call "employeurs->executeActiveFilters()" |
| 18 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id FROM company_profile c WHERE (c.id = ?) LIMIT 1 - (6) |
| 19 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_activeFilters.php" |
| 20 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.nom AS c__nom, c.lang AS c__lang FROM company_profile_translation c WHERE (c.id IN (?)) - (6) |
| 21 | main | Call "employeurs->executeFilterForm()" |
| 22 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM company_profile c WHERE c.id = ? - (6) |
| 23 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_filterForm.php" |
| 24 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c2.id AS c2__id, c2.nom AS c2__nom, c2.lang AS c2__lang, w.website_id AS w__website_id, w.company_profile_id AS w__company_profile_id FROM company_profile c LEFT JOIN company_profile_translation c2 ON c.id = c2.id INNER JOIN website_company_profile w ON c.id = w.company_profile_id WHERE (c2.lang = ? AND w.website_id = ?) ORDER BY c2.nom ASC - (fr, 1) |
| 25 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c2.id AS c2__id, c2.nom AS c2__nom, c2.lang AS c2__lang, c3.id AS c3__id, c3.nom AS c3__nom, c3.company_profile_id AS c3__company_profile_id, c3.company_sector_id AS c3__company_sector_id, c3.methode_facturation AS c3__methode_facturation, c3.methode_candidature AS c3__methode_candidature, c3.logo AS c3__logo, c3.pays AS c3__pays, c3.adresse1 AS c3__adresse1, c3.adresse2 AS c3__adresse2, c3.ville AS c3__ville, c3.province_id AS c3__province_id, c3.region_id AS c3__region_id, c3.codepostal AS c3__codepostal, c3.latitude AS c3__latitude, c3.longitude AS c3__longitude, c3.siteweb AS c3__siteweb, c3.email AS c3__email, c3.tel AS c3__tel, c3.tel_ext AS c3__tel_ext, c3.fax AS c3__fax, c3.user_id AS c3__user_id, c3.featured AS c3__featured, c3.created_at AS c3__created_at, c3.updated_at AS c3__updated_at, c4.id AS c4__id, c4.website_id AS c4__website_id, c4.company_id AS c4__company_id, c4.show_on_homepage AS c4__show_on_homepage, c4.video AS c4__video, c4.created_at AS c4__created_at, c4.updated_at AS c4__updated_at FROM company_sector c LEFT JOIN company_sector_translation c2 ON c.id = c2.id INNER JOIN company c3 ON c.id = c3.company_sector_id INNER JOIN company_portail c4 ON c3.id = c4.company_id WHERE (c2.lang = ? AND c4.website_id = ?) ORDER BY c2.nom ASC - (fr, 1) |
| 26 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.pays AS p__pays, p2.id AS p2__id, p2.nom AS p2__nom, p2.lang AS p2__lang, c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM province p LEFT JOIN province_translation p2 ON p.id = p2.id INNER JOIN company c ON p.id = c.province_id WHERE (p2.lang = ?) ORDER BY p2.nom ASC - (fr) |
| 27 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r2.id AS r2__id, r2.nom AS r2__nom, r2.lang AS r2__lang, c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM region r LEFT JOIN region_translation r2 ON r.id = r2.id INNER JOIN company c ON r.id = c.region_id WHERE (r2.lang = ?) ORDER BY r2.nom ASC - (fr) |
| 28 | main | Call "pub->executeDfpBodyTag()" |
| 29 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 30 | main | Call "pub->executeDfpBodyTag()" |
| 31 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 32 | Doctrine_Connection_Statement | execute : SELECT DISTINCT c5.id FROM company c5 LEFT JOIN company_translation c6 ON c5.id = c6.id LEFT JOIN company_portail c7 ON c5.id = c7.company_id LEFT JOIN company_portail_translation c8 ON c7.id = c8.id WHERE c8.lang = ? AND c7.website_id = ? AND c5.company_profile_id = ? ORDER BY c5.featured DESC, c5.nom ASC LIMIT 5 OFFSET 30 - (fr, 1, 6) |
| 33 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company c LEFT JOIN company_translation c2 ON c.id = c2.id LEFT JOIN company_portail c3 ON c.id = c3.company_id LEFT JOIN company_portail_translation c4 ON c3.id = c4.id WHERE c.id IN ('796') AND (c4.lang = ? AND c3.website_id = ? AND c.company_profile_id = ?) ORDER BY c.featured DESC, c.nom ASC - (fr, 1, 6) |
| 34 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_company_resume.php" |
| 35 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.website_id AS c__website_id, c.company_id AS c__company_id, c.show_on_homepage AS c__show_on_homepage, c.video AS c__video, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company_portail c WHERE (c.website_id = ? AND c.company_id = ?) - (1, 796) |
| 36 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.introduction AS c__introduction, c.missions AS c__missions, c.specialite_company AS c__specialite_company, c.programmes_speciaux AS c__programmes_speciaux, c.clientele AS c__clientele, c.ambiance AS c__ambiance, c.possibilites_carriere AS c__possibilites_carriere, c.temoignages AS c__temoignages, c.processus_embauche AS c__processus_embauche, c.portrait_quartier AS c__portrait_quartier, c.conditions_travail AS c__conditions_travail, c.services_offerts AS c__services_offerts, c.distinctions AS c__distinctions, c.autres_informations AS c__autres_informations, c.lang AS c__lang FROM company_portail_translation c WHERE (c.id IN (?)) - (414) |
| 37 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 38 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 39 | main | Call "page->executeTitle()" |
| 40 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 41 | sfPartialView | Render "sf_app_dir/modules/page/templates/_title.php" |
| 42 | main | Get slot "og_tags" |
| 43 | main | Call "pub->executeDfpHeadTag()" |
| 44 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 45 | main | Call "pub->executeDfpHeadTag()" |
| 46 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 47 | main | Call "page->executeFacebookInitScript()" |
| 48 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 49 | sfPartialView | Render "sf_app_dir/modules/page/templates/_facebookInitScript.php" |
| 50 | main | Call "page->executeMenu()" |
| 51 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, haut) |
| 52 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
| 53 | main | Call "page->executeSocialIcons()" |
| 54 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 55 | sfPartialView | Render "sf_app_dir/modules/page/templates/_socialIcons.php" |
| 56 | main | Call "page->executeMenu()" |
| 57 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, navigation_principale) |
| 58 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
| 59 | main | Call "offres->executeSearchBar()" |
| 60 | sfPartialView | Render "sf_app_dir/modules/offres/templates/_searchBar.php" |
| 61 | main | Call "pub->executeLeaderboard()" |
| 62 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 63 | main | Get slot "sidebar-left" |
| 64 | main | Call "page->executeMenu()" |
| 65 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_gauche) |
| 66 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
| 67 | main | Call "page->executeMenu()" |
| 68 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_milieu) |
| 69 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
| 70 | main | Call "page->executeMenu()" |
| 71 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_droite) |
| 72 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
| 73 | main | Call "page->executeAnalytics()" |
| 74 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
| 75 | sfPartialView | Render "sf_app_dir/modules/page/templates/_analytics.php" |
| 76 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 77 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 45 | 3653.96 | 51 |
| Factories | 1 | 1892.80 | 26 |
| Database (Doctrine) | 32 | 0.12 | 0 |
| Action "employeurs/list" | 1 | 43.30 | 0 |
| View "Success" for "employeurs/list" | 1 | 3194.85 | 45 |
| Component "employeurs/activeFilters" | 1 | 32.95 | 0 |
| Partial "employeurs/_activeFilters" | 1 | 3.47 | 0 |
| Component "employeurs/filterForm" | 1 | 7.32 | 0 |
| Partial "employeurs/_filterForm" | 1 | 2900.71 | 41 |
| Component "pub/dfpBodyTag" | 2 | 8.14 | 0 |
| Partial "employeurs/_company_resume" | 1 | 17.55 | 0 |
| Component "page/title" | 1 | 5.39 | 0 |
| Partial "page/_title" | 1 | 0.53 | 0 |
| Component "pub/dfpHeadTag" | 2 | 9.93 | 0 |
| Component "page/facebookInitScript" | 1 | 5.25 | 0 |
| Partial "page/_facebookInitScript" | 1 | 0.54 | 0 |
| Component "page/menu" | 5 | 48.38 | 0 |
| Partial "page/_menu" | 5 | 30.80 | 0 |
| Component "page/socialIcons" | 1 | 15.06 | 0 |
| Partial "page/_socialIcons" | 1 | 0.91 | 0 |
| Component "offres/searchBar" | 1 | 5.07 | 0 |
| Partial "offres/_searchBar" | 1 | 0.74 | 0 |
| Component "pub/leaderboard" | 1 | 10.55 | 0 |
| Component "page/analytics" | 1 | 5.88 | 0 |
| Partial "page/_analytics" | 1 | 0.55 | 0 |
SET NAMES 'UTF8'
SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.domain = 'emploisprofessionnelsensante.com') LIMIT 1
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT COUNT(*) AS num_results FROM company_profile c WHERE c.id = '6'
SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM company c LEFT JOIN company_translation c2 ON c.id = c2.id LEFT JOIN company_portail c3 ON c.id = c3.company_id LEFT JOIN company_portail_translation c4 ON c3.id = c4.id WHERE c4.lang = 'fr' AND c3.website_id = '1' AND c.company_profile_id = '6' GROUP BY c.id) dctrn_count_query
SELECT w.id AS w__id, w.titre AS w__titre, w.video_employeur AS w__video_employeur, w.video_candidat AS w__video_candidat, w.meta_title AS w__meta_title, w.meta_description AS w__meta_description, w.meta_keywords AS w__meta_keywords, w.id_analytics AS w__id_analytics, w.titre_section_tendances AS w__titre_section_tendances, w.lang AS w__lang FROM website_translation w WHERE (w.id IN ('1'))
SELECT c.id AS c__id FROM company_profile c WHERE (c.id = '6') LIMIT 1
SELECT c.id AS c__id, c.nom AS c__nom, c.lang AS c__lang FROM company_profile_translation c WHERE (c.id IN ('6'))
SELECT COUNT(*) AS num_results FROM company_profile c WHERE c.id = '6'
SELECT c.id AS c__id, c2.id AS c2__id, c2.nom AS c2__nom, c2.lang AS c2__lang, w.website_id AS w__website_id, w.company_profile_id AS w__company_profile_id FROM company_profile c LEFT JOIN company_profile_translation c2 ON c.id = c2.id INNER JOIN website_company_profile w ON c.id = w.company_profile_id WHERE (c2.lang = 'fr' AND w.website_id = '1') ORDER BY c2.nom ASC
SELECT c.id AS c__id, c2.id AS c2__id, c2.nom AS c2__nom, c2.lang AS c2__lang, c3.id AS c3__id, c3.nom AS c3__nom, c3.company_profile_id AS c3__company_profile_id, c3.company_sector_id AS c3__company_sector_id, c3.methode_facturation AS c3__methode_facturation, c3.methode_candidature AS c3__methode_candidature, c3.logo AS c3__logo, c3.pays AS c3__pays, c3.adresse1 AS c3__adresse1, c3.adresse2 AS c3__adresse2, c3.ville AS c3__ville, c3.province_id AS c3__province_id, c3.region_id AS c3__region_id, c3.codepostal AS c3__codepostal, c3.latitude AS c3__latitude, c3.longitude AS c3__longitude, c3.siteweb AS c3__siteweb, c3.email AS c3__email, c3.tel AS c3__tel, c3.tel_ext AS c3__tel_ext, c3.fax AS c3__fax, c3.user_id AS c3__user_id, c3.featured AS c3__featured, c3.created_at AS c3__created_at, c3.updated_at AS c3__updated_at, c4.id AS c4__id, c4.website_id AS c4__website_id, c4.company_id AS c4__company_id, c4.show_on_homepage AS c4__show_on_homepage, c4.video AS c4__video, c4.created_at AS c4__created_at, c4.updated_at AS c4__updated_at FROM company_sector c LEFT JOIN company_sector_translation c2 ON c.id = c2.id INNER JOIN company c3 ON c.id = c3.company_sector_id INNER JOIN company_portail c4 ON c3.id = c4.company_id WHERE (c2.lang = 'fr' AND c4.website_id = '1') ORDER BY c2.nom ASC
SELECT p.id AS p__id, p.pays AS p__pays, p2.id AS p2__id, p2.nom AS p2__nom, p2.lang AS p2__lang, c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM province p LEFT JOIN province_translation p2 ON p.id = p2.id INNER JOIN company c ON p.id = c.province_id WHERE (p2.lang = 'fr') ORDER BY p2.nom ASC
SELECT r.id AS r__id, r2.id AS r2__id, r2.nom AS r2__nom, r2.lang AS r2__lang, c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM region r LEFT JOIN region_translation r2 ON r.id = r2.id INNER JOIN company c ON r.id = c.region_id WHERE (r2.lang = 'fr') ORDER BY r2.nom ASC
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT DISTINCT c5.id FROM company c5 LEFT JOIN company_translation c6 ON c5.id = c6.id LEFT JOIN company_portail c7 ON c5.id = c7.company_id LEFT JOIN company_portail_translation c8 ON c7.id = c8.id WHERE c8.lang = 'fr' AND c7.website_id = '1' AND c5.company_profile_id = '6' ORDER BY c5.featured DESC, c5.nom ASC LIMIT 5 OFFSET 30
SELECT c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company c LEFT JOIN company_translation c2 ON c.id = c2.id LEFT JOIN company_portail c3 ON c.id = c3.company_id LEFT JOIN company_portail_translation c4 ON c3.id = c4.id WHERE c.id IN ('796') AND (c4.lang = 'fr' AND c3.website_id = '1' AND c.company_profile_id = '6') ORDER BY c.featured DESC, c.nom ASC
SELECT c.id AS c__id, c.website_id AS c__website_id, c.company_id AS c__company_id, c.show_on_homepage AS c__show_on_homepage, c.video AS c__video, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company_portail c WHERE (c.website_id = '1' AND c.company_id = '796')
SELECT c.id AS c__id, c.introduction AS c__introduction, c.missions AS c__missions, c.specialite_company AS c__specialite_company, c.programmes_speciaux AS c__programmes_speciaux, c.clientele AS c__clientele, c.ambiance AS c__ambiance, c.possibilites_carriere AS c__possibilites_carriere, c.temoignages AS c__temoignages, c.processus_embauche AS c__processus_embauche, c.portrait_quartier AS c__portrait_quartier, c.conditions_travail AS c__conditions_travail, c.services_offerts AS c__services_offerts, c.distinctions AS c__distinctions, c.autres_informations AS c__autres_informations, c.lang AS c__lang FROM company_portail_translation c WHERE (c.id IN ('414'))
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'haut') ORDER BY p.ordre ASC
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'navigation_principale') ORDER BY p.ordre ASC
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'bas_gauche') ORDER BY p.ordre ASC
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'bas_milieu') ORDER BY p.ordre ASC
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'bas_droite') ORDER BY p.ordre ASC
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1