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: { type: '8' }
  module: offres
  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!'
  keywords: 'Emploi en santé'
  title: 'Liste des offres d''emploi en santé'
  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_offer_filters: { f: { type: '8', s: '', l: '', lll: '', company: null, specialite: null, region: null, salaire_min: '', statut: null, experience: null } }, website_id: '1', website_short_code: sante }
culture: fr
authenticated: false
credentials: {  }
lastRequest: 1745485005

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_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: { type: '8' }
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: 9354639e4a2261ae-ORD
  HTTP_CF_VISITOR: '{"scheme":"https"}'
  HTTP_HOST: www.emploisprofessionnelsensante.com
  HTTP_REFERER: 'https://emploisprofessionnelsensante.com/frontend_dev.php/fr/offres?f%5Btype%5D=8'
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])'
  HTTP_X_FORWARDED_FOR: 13.59.50.189
  HTTP_X_FORWARDED_PROTO: https
  PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
  PATH_INFO: /fr/offres
  PATH_TRANSLATED: 'redirect:/index.php/offres'
  PHP_SELF: /frontend_dev.php/fr/offres
  QUERY_STRING: f%5Btype%5D=8
  REMOTE_ADDR: 13.59.50.189
  REMOTE_PORT: '38310'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1745485004
  REQUEST_TIME_FLOAT: 1745485004.6201
  REQUEST_URI: '/frontend_dev.php/fr/offres?f%5Btype%5D=8'
  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: aAn8zLyBvgUIXS4WljmyyQAAARI
  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 (OffreFilterForm)
  • $form['s'] (sfWidgetFormInputText)
  • $form['l'] (sfWidgetFormInputText)
  • $form['lll'] (sfWidgetFormInputHidden)
  • $form['region'] (sfWidgetFormDoctrineChoice)
  • $form['company'] (sfWidgetFormDoctrineChoice)
  • $form['specialite'] (sfWidgetFormDoctrineChoice)
  • $form['salaire_min'] (sfWidgetFormInputText)
  • $form['type'] (sfWidgetFormDoctrineChoice)
  • $form['statut'] (sfWidgetFormDoctrineChoice)
  • $form['experience'] (sfWidgetFormChoice)
• $pager (sfDoctrinePager)

Parameters:

• $type (Typeoffre)
• $statut (NULL)
• $experience (NULL)
• $company (NULL)
• $specialite (NULL)
• $region (NULL)
• $active_filters (array)

Parameters:

• $form (OffreFilterForm)
  • $form['s'] (sfWidgetFormInputText)
  • $form['l'] (sfWidgetFormInputText)
  • $form['lll'] (sfWidgetFormInputHidden)
  • $form['region'] (sfWidgetFormDoctrineChoice)
  • $form['company'] (sfWidgetFormDoctrineChoice)
  • $form['specialite'] (sfWidgetFormDoctrineChoice)
  • $form['salaire_min'] (sfWidgetFormInputText)
  • $form['type'] (sfWidgetFormDoctrineChoice)
  • $form['statut'] (sfWidgetFormDoctrineChoice)
  • $form['experience'] (sfWidgetFormChoice)
• $form_values (array)

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)

Doctrine Version: 1.2.4

1. SET NAMES 'UTF8'

   0.00s, "doctrine" connection

2. SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

   0.00s, "doctrine" connection

3. 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

   0.00s, "doctrine" connection

4. 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

   0.00s, "doctrine" connection

5. SELECT w.website_id AS w__website_id, w.specialite_id AS w__specialite_id FROM website_specialite w WHERE (w.website_id IN ('1'))

   0.00s, "doctrine" connection

6. 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

   0.00s, "doctrine" connection

7. SELECT COUNT(*) AS num_results FROM typeoffre t WHERE t.id = '8'

   0.00s, "doctrine" connection

8. SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o INNER JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON (o.id = o3.offre_id) INNER JOIN specialite s ON s.id = o3.specialite_id INNER JOIN specialite_translation s2 ON s.id = s2.id INNER JOIN typeoffre t ON o.typeoffre_id = t.id INNER JOIN typeoffre_translation t2 ON t.id = t2.id INNER JOIN statutoffre s3 ON o.statutoffre_id = s3.id INNER JOIN statutoffre_translation s4 ON s3.id = s4.id INNER JOIN company c ON o.company_id = c.id INNER JOIN company_portail c2 ON c.id = c2.company_id WHERE s2.lang = 'fr' AND s.id IN ('1', '2', '3', '4', '5', '6', '7', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '33', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '77', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '654', '657', '669', '674', '683', '687', '689', '690', '693', '707', '710', '806', '807', '820', '867', '878', '886', '887', '918', '924', '925', '990', '1037', '1043', '1079', '1084', '1085', '1194') AND t2.lang = 'fr' AND t2.lang = 'fr' AND c2.website_id = '1' AND o.actif = 1 AND o.typeoffre_id = '8' GROUP BY o.id) dctrn_count_query

   0.00s, "doctrine" connection

9. 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'))

   0.00s, "doctrine" connection

10. SELECT t.id AS t__id FROM typeoffre t WHERE (t.id = '8') LIMIT 1

    0.00s, "doctrine" connection

11. SELECT t.id AS t__id, t.nom AS t__nom, t.lang AS t__lang FROM typeoffre_translation t WHERE (t.id IN ('8'))

    0.00s, "doctrine" connection

12. 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

    0.00s, "doctrine" connection

13. SELECT COUNT(*) AS num_results FROM typeoffre t WHERE t.id = '8'

    0.00s, "doctrine" connection

14. SELECT r.id AS r__id, r2.id AS r2__id, r2.lang AS r2__lang, r2.nom AS r2__nom FROM region r INNER JOIN region_translation r2 ON r.id = r2.id INNER JOIN company c ON r.id = c.region_id INNER JOIN offre o ON c.id = o.company_id INNER JOIN offre_specialite o2 ON (o.id = o2.offre_id) INNER JOIN specialite s ON s.id = o2.specialite_id WHERE (s.id IN ('1', '2', '3', '4', '5', '6', '7', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '33', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '77', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '654', '657', '669', '674', '683', '687', '689', '690', '693', '707', '710', '806', '807', '820', '867', '878', '886', '887', '918', '924', '925', '990', '1037', '1043', '1079', '1084', '1085', '1194') AND o.actif = '1' AND r2.lang = 'fr') ORDER BY r2.nom ASC

    0.36s, "doctrine" connection

15. SELECT c.id AS c__id, c.nom AS c__nom FROM company c INNER JOIN offre o ON c.id = o.company_id INNER JOIN offre_specialite o2 ON (o.id = o2.offre_id) INNER JOIN specialite s ON s.id = o2.specialite_id INNER JOIN company_portail c2 ON c.id = c2.company_id WHERE (c2.website_id = '1' AND o.actif = '1') ORDER BY c.nom ASC

    0.25s, "doctrine" connection

16. SELECT s.id AS s__id, s2.id AS s2__id, s2.lang AS s2__lang, s2.nom AS s2__nom FROM specialite s INNER JOIN specialite_translation s2 ON s.id = s2.id INNER JOIN website_specialite w ON s.id = w.specialite_id INNER JOIN offre_specialite o2 ON (s.id = o2.specialite_id) INNER JOIN offre o ON o.id = o2.offre_id WHERE (s2.lang = 'fr' AND w.website_id = '1') ORDER BY s2.nom ASC

    0.99s, "doctrine" connection

17. SELECT t.id AS t__id, t2.id AS t2__id, t2.lang AS t2__lang, t2.nom AS t2__nom FROM typeoffre t INNER JOIN typeoffre_translation t2 ON t.id = t2.id WHERE (t2.lang = 'fr') ORDER BY t.id ASC

    0.00s, "doctrine" connection

18. SELECT s.id AS s__id, s2.id AS s2__id, s2.lang AS s2__lang, s2.nom AS s2__nom FROM statutoffre s INNER JOIN statutoffre_translation s2 ON s.id = s2.id WHERE (s2.lang = 'fr') ORDER BY s.id ASC

    0.00s, "doctrine" connection

19. 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

    0.00s, "doctrine" connection

20. 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

    0.00s, "doctrine" connection

21. 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

    0.00s, "doctrine" connection

22. 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

    0.00s, "doctrine" connection

23. 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

    0.00s, "doctrine" connection

24. 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

    0.00s, "doctrine" connection

25. 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

    0.00s, "doctrine" connection

26. 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

    0.00s, "doctrine" connection

27. 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

    0.00s, "doctrine" connection

28. 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

    0.00s, "doctrine" connection

29. 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

    0.00s, "doctrine" connection

30. 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

    0.00s, "doctrine" connection

31. 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

    0.00s, "doctrine" connection

32. 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

    0.00s, "doctrine" connection