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: { company: '1015' } 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: { company: '1015', s: '', l: '', lll: '', specialite: null, region: null, salaire_min: '', type: null, statut: null, experience: null } }, website_id: '1', website_short_code: sante } culture: fr authenticated: false credentials: { } lastRequest: 1745475460
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: { company: '1015' } 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: 93537a955df361fd-ORD HTTP_CF_VISITOR: '{"scheme":"https"}' HTTP_HOST: www.emploisprofessionnelsensante.com HTTP_REFERER: 'https://emploisprofessionnelsensante.com/frontend_dev.php/fr/offres?f%5Bcompany%5D=1015' HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])' HTTP_X_FORWARDED_FOR: 3.141.47.84 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%5Bcompany%5D=1015 REMOTE_ADDR: 3.141.47.84 REMOTE_PORT: '60100' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1745475459 REQUEST_TIME_FLOAT: 1745475459.5087 REQUEST_URI: '/frontend_dev.php/fr/offres?f%5Bcompany%5D=1015' 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: aAnXg5seQaPlUw00pAlGeAAAAVQ 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
(NULL)$statut
(NULL)$experience
(NULL)$company
(NULL)$etablissement
(Company)$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)$specialites_from_company
(Doctrine_Collection)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:
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 | ![]() | Connect sfRoute "sf_guard_signin" (/guard/login) |
2 | ![]() | Connect sfRoute "sf_guard_signout" (/guard/logout) |
3 | ![]() | exec : SET NAMES 'UTF8' - () |
4 | ![]() | query : SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')) - () |
5 | ![]() | 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 | ![]() | Match route "offres_liste" (/:sf_culture/offres) for /fr/offres with parameters array ( 'website_id' => '1', 'website_short_code' => 'sante', 'module' => 'offres', 'action' => 'list', 'sf_culture' => 'fr',) |
7 | ![]() | Executing filter "sfRenderingFilter" |
8 | ![]() | Executing filter "sfExecutionFilter" |
9 | ![]() | Call "offresActions->executeList()" |
10 | ![]() | 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 | ![]() | execute : 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) |
12 | ![]() | 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) |
13 | ![]() | execute : SELECT COUNT(*) AS num_results FROM company c WHERE c.id = ? - (1015) |
14 | ![]() | execute : 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 = ? AND s.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t2.lang = ? AND t2.lang = ? AND c2.website_id = ? AND o.actif = 1 AND o.company_id = ? GROUP BY o.id) dctrn_count_query - (fr, 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, fr, fr, 1, 1015) |
15 | ![]() | 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) |
16 | ![]() | Render "sf_app_dir/modules/offres/templates/listSuccess.php" |
17 | ![]() | Set slot "title" |
18 | ![]() | Set slot "sidebar-left" |
19 | ![]() | Call "offres->executeActiveFilters()" |
20 | ![]() | 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 WHERE (c.id = ?) LIMIT 1 - (1015) |
21 | ![]() | Render "sf_app_dir/modules/offres/templates/_activeFilters.php" |
22 | ![]() | Call "offres->executeFilterForm()" |
23 | ![]() | 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) |
24 | ![]() | execute : SELECT COUNT(*) AS num_results FROM company c WHERE c.id = ? - (1015) |
25 | ![]() | execute : SELECT s.id AS s__id, o.offre_id AS o__offre_id, o.specialite_id AS o__specialite_id, o2.id AS o2__id, o2.company_id AS o2__company_id, o2.typeoffre_id AS o2__typeoffre_id, o2.statutoffre_id AS o2__statutoffre_id, o2.experience_requise AS o2__experience_requise, o2.salaire_min AS o2__salaire_min, o2.salaire_max AS o2__salaire_max, o2.experienceoffre_id AS o2__experienceoffre_id, o2.salaireoffre_id AS o2__salaireoffre_id, o2.ville AS o2__ville, o2.adresse AS o2__adresse, o2.codepostal AS o2__codepostal, o2.region_id AS o2__region_id, o2.date_fin_affichage AS o2__date_fin_affichage, o2.actif AS o2__actif, o2.vues AS o2__vues, o2.siteweb AS o2__siteweb, o2.email AS o2__email, o2.sujet AS o2__sujet, o2.clics AS o2__clics, o2.archived AS o2__archived, o2.featured AS o2__featured, o2.created_at AS o2__created_at, o2.updated_at AS o2__updated_at FROM specialite s INNER JOIN offre_specialite o ON s.id = o.specialite_id INNER JOIN offre o2 ON o.offre_id = o2.id WHERE (o2.company_id = ? AND o2.actif = 1) - (1015) |
26 | ![]() | Render "sf_app_dir/modules/offres/templates/_filterForm.php" |
27 | ![]() | execute : 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o.actif = ? AND r2.lang = ?) ORDER BY r2.nom ASC - (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, 1, fr) |
28 | ![]() | execute : 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 = ? AND o.actif = ?) ORDER BY c.nom ASC - (1, 1) |
29 | ![]() | execute : 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 = ? AND w.website_id = ?) ORDER BY s2.nom ASC - (fr, 1) |
30 | ![]() | execute : 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 = ?) ORDER BY t.id ASC - (fr) |
31 | ![]() | execute : 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 = ?) ORDER BY s.id ASC - (fr) |
32 | ![]() | Call "pub->executeSkyscraper()" |
33 | ![]() | 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) |
34 | ![]() | Call "pub->executeDfpBodyTag()" |
35 | ![]() | 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) |
36 | ![]() | Decorate content with "sf_app_dir/templates/layout.php" |
37 | ![]() | Render "sf_app_dir/templates/layout.php" |
38 | ![]() | Call "page->executeTitle()" |
39 | ![]() | 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) |
40 | ![]() | Render "sf_app_dir/modules/page/templates/_title.php" |
41 | ![]() | Get slot "og_tags" |
42 | ![]() | Call "pub->executeDfpHeadTag()" |
43 | ![]() | 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) |
44 | ![]() | Call "pub->executeDfpHeadTag()" |
45 | ![]() | 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) |
46 | ![]() | Call "page->executeFacebookInitScript()" |
47 | ![]() | 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) |
48 | ![]() | Render "sf_app_dir/modules/page/templates/_facebookInitScript.php" |
49 | ![]() | Call "page->executeMenu()" |
50 | ![]() | 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) |
51 | ![]() | Render "sf_app_dir/modules/page/templates/_menu.php" |
52 | ![]() | Call "page->executeSocialIcons()" |
53 | ![]() | 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) |
54 | ![]() | Render "sf_app_dir/modules/page/templates/_socialIcons.php" |
55 | ![]() | Call "page->executeMenu()" |
56 | ![]() | 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) |
57 | ![]() | Render "sf_app_dir/modules/page/templates/_menu.php" |
58 | ![]() | Call "offres->executeSearchBar()" |
59 | ![]() | Render "sf_app_dir/modules/offres/templates/_searchBar.php" |
60 | ![]() | Call "pub->executeLeaderboard()" |
61 | ![]() | 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) |
62 | ![]() | Get slot "sidebar-left" |
63 | ![]() | Call "page->executeMenu()" |
64 | ![]() | 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) |
65 | ![]() | Render "sf_app_dir/modules/page/templates/_menu.php" |
66 | ![]() | Call "page->executeMenu()" |
67 | ![]() | 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) |
68 | ![]() | Render "sf_app_dir/modules/page/templates/_menu.php" |
69 | ![]() | Call "page->executeMenu()" |
70 | ![]() | 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) |
71 | ![]() | Render "sf_app_dir/modules/page/templates/_menu.php" |
72 | ![]() | Call "page->executeAnalytics()" |
73 | ![]() | 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) |
74 | ![]() | Render "sf_app_dir/modules/page/templates/_analytics.php" |
75 | ![]() | Send status "HTTP/1.1 200 OK" |
76 | ![]() | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 45 | 1095.84 | 16 |
Factories | 1 | 1145.72 | 17 |
Database (Doctrine) | 32 | 0.06 | 0 |
Action "offres/list" | 1 | 72.30 | 1 |
View "Success" for "offres/list" | 1 | 5259.37 | 80 |
Component "offres/activeFilters" | 1 | 2.91 | 0 |
Partial "offres/_activeFilters" | 1 | 1.00 | 0 |
Component "offres/filterForm" | 1 | 347.04 | 5 |
Partial "offres/_filterForm" | 1 | 4771.20 | 73 |
Component "pub/skyscraper" | 1 | 4.05 | 0 |
Component "pub/dfpBodyTag" | 1 | 4.37 | 0 |
Component "page/title" | 1 | 3.26 | 0 |
Partial "page/_title" | 1 | 0.39 | 0 |
Component "pub/dfpHeadTag" | 2 | 6.30 | 0 |
Component "page/facebookInitScript" | 1 | 2.97 | 0 |
Partial "page/_facebookInitScript" | 1 | 0.45 | 0 |
Component "page/menu" | 5 | 38.35 | 0 |
Partial "page/_menu" | 5 | 29.86 | 0 |
Component "page/socialIcons" | 1 | 4.69 | 0 |
Partial "page/_socialIcons" | 1 | 1.02 | 0 |
Component "offres/searchBar" | 1 | 1.08 | 0 |
Partial "offres/_searchBar" | 1 | 0.81 | 0 |
Component "pub/leaderboard" | 1 | 4.75 | 0 |
Component "page/analytics" | 1 | 5.49 | 0 |
Partial "page/_analytics" | 1 | 0.54 | 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 w.website_id AS w__website_id, w.specialite_id AS w__specialite_id FROM website_specialite w WHERE (w.website_id IN ('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 c WHERE c.id = '1015'
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.company_id = '1015' GROUP BY o.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, 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 WHERE (c.id = '1015') 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 c WHERE c.id = '1015'
SELECT s.id AS s__id, o.offre_id AS o__offre_id, o.specialite_id AS o__specialite_id, o2.id AS o2__id, o2.company_id AS o2__company_id, o2.typeoffre_id AS o2__typeoffre_id, o2.statutoffre_id AS o2__statutoffre_id, o2.experience_requise AS o2__experience_requise, o2.salaire_min AS o2__salaire_min, o2.salaire_max AS o2__salaire_max, o2.experienceoffre_id AS o2__experienceoffre_id, o2.salaireoffre_id AS o2__salaireoffre_id, o2.ville AS o2__ville, o2.adresse AS o2__adresse, o2.codepostal AS o2__codepostal, o2.region_id AS o2__region_id, o2.date_fin_affichage AS o2__date_fin_affichage, o2.actif AS o2__actif, o2.vues AS o2__vues, o2.siteweb AS o2__siteweb, o2.email AS o2__email, o2.sujet AS o2__sujet, o2.clics AS o2__clics, o2.archived AS o2__archived, o2.featured AS o2__featured, o2.created_at AS o2__created_at, o2.updated_at AS o2__updated_at FROM specialite s INNER JOIN offre_specialite o ON s.id = o.specialite_id INNER JOIN offre o2 ON o.offre_id = o2.id WHERE (o2.company_id = '1015' AND o2.actif = 1)
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
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
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
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
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
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 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