# |
type |
message |
1 | sfPatternRouting | Connect sfRoute "sf_guard_signin" (/guard/login) |
2 | sfPatternRouting | Connect sfRoute "sf_guard_signout" (/guard/logout) |
3 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
4 | Doctrine_Connection_Mysql | query : SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')) - () |
5 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.domain = ?) LIMIT 1 - (emploisprofessionnelsensante.com) |
6 | sfPatternRouting | Match route "employeurs_liste" (/:sf_culture/employeurs) for /fr/employeurs with parameters array ( 'website_id' => '1', 'website_short_code' => 'sante', 'module' => 'employeurs', 'action' => 'list', 'sf_culture' => 'fr',) |
7 | sfFilterChain | Executing filter "sfRenderingFilter" |
8 | sfFilterChain | Executing filter "sfExecutionFilter" |
9 | employeursActions | Call "employeursActions->executeList()" |
10 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
11 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM company c LEFT JOIN company_translation c2 ON c.id = c2.id LEFT JOIN company_portail c3 ON c.id = c3.company_id LEFT JOIN company_portail_translation c4 ON c3.id = c4.id WHERE c4.lang = ? AND c3.website_id = ? GROUP BY c.id) dctrn_count_query - (fr, 1) |
12 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.titre AS w__titre, w.video_employeur AS w__video_employeur, w.video_candidat AS w__video_candidat, w.meta_title AS w__meta_title, w.meta_description AS w__meta_description, w.meta_keywords AS w__meta_keywords, w.id_analytics AS w__id_analytics, w.titre_section_tendances AS w__titre_section_tendances, w.lang AS w__lang FROM website_translation w WHERE (w.id IN (?)) - (1) |
13 | sfPHPView | Render "sf_app_dir/modules/employeurs/templates/listSuccess.php" |
14 | main | Set slot "title" |
15 | main | Set slot "sidebar-left" |
16 | main | Call "employeurs->executeActiveFilters()" |
17 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_activeFilters.php" |
18 | main | Call "employeurs->executeFilterForm()" |
19 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_filterForm.php" |
20 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c2.id AS c2__id, c2.nom AS c2__nom, c2.lang AS c2__lang, w.website_id AS w__website_id, w.company_profile_id AS w__company_profile_id FROM company_profile c LEFT JOIN company_profile_translation c2 ON c.id = c2.id INNER JOIN website_company_profile w ON c.id = w.company_profile_id WHERE (c2.lang = ? AND w.website_id = ?) ORDER BY c2.nom ASC - (fr, 1) |
21 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c2.id AS c2__id, c2.nom AS c2__nom, c2.lang AS c2__lang, c3.id AS c3__id, c3.nom AS c3__nom, c3.company_profile_id AS c3__company_profile_id, c3.company_sector_id AS c3__company_sector_id, c3.methode_facturation AS c3__methode_facturation, c3.methode_candidature AS c3__methode_candidature, c3.logo AS c3__logo, c3.pays AS c3__pays, c3.adresse1 AS c3__adresse1, c3.adresse2 AS c3__adresse2, c3.ville AS c3__ville, c3.province_id AS c3__province_id, c3.region_id AS c3__region_id, c3.codepostal AS c3__codepostal, c3.latitude AS c3__latitude, c3.longitude AS c3__longitude, c3.siteweb AS c3__siteweb, c3.email AS c3__email, c3.tel AS c3__tel, c3.tel_ext AS c3__tel_ext, c3.fax AS c3__fax, c3.user_id AS c3__user_id, c3.featured AS c3__featured, c3.created_at AS c3__created_at, c3.updated_at AS c3__updated_at, c4.id AS c4__id, c4.website_id AS c4__website_id, c4.company_id AS c4__company_id, c4.show_on_homepage AS c4__show_on_homepage, c4.video AS c4__video, c4.created_at AS c4__created_at, c4.updated_at AS c4__updated_at FROM company_sector c LEFT JOIN company_sector_translation c2 ON c.id = c2.id INNER JOIN company c3 ON c.id = c3.company_sector_id INNER JOIN company_portail c4 ON c3.id = c4.company_id WHERE (c2.lang = ? AND c4.website_id = ?) ORDER BY c2.nom ASC - (fr, 1) |
22 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.pays AS p__pays, p2.id AS p2__id, p2.nom AS p2__nom, p2.lang AS p2__lang, c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM province p LEFT JOIN province_translation p2 ON p.id = p2.id INNER JOIN company c ON p.id = c.province_id WHERE (p2.lang = ?) ORDER BY p2.nom ASC - (fr) |
23 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r2.id AS r2__id, r2.nom AS r2__nom, r2.lang AS r2__lang, c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM region r LEFT JOIN region_translation r2 ON r.id = r2.id INNER JOIN company c ON r.id = c.region_id WHERE (r2.lang = ?) ORDER BY r2.nom ASC - (fr) |
24 | main | Call "pub->executeDfpBodyTag()" |
25 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
26 | main | Call "pub->executeDfpBodyTag()" |
27 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
28 | Doctrine_Connection_Statement | execute : SELECT DISTINCT c5.id FROM company c5 LEFT JOIN company_translation c6 ON c5.id = c6.id LEFT JOIN company_portail c7 ON c5.id = c7.company_id LEFT JOIN company_portail_translation c8 ON c7.id = c8.id WHERE c8.lang = ? AND c7.website_id = ? ORDER BY c5.featured DESC, c5.nom ASC LIMIT 5 OFFSET 70 - (fr, 1) |
29 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company c LEFT JOIN company_translation c2 ON c.id = c2.id LEFT JOIN company_portail c3 ON c.id = c3.company_id LEFT JOIN company_portail_translation c4 ON c3.id = c4.id WHERE c.id IN ('3402', '2087', '2331', '1354', '1362') AND (c4.lang = ? AND c3.website_id = ?) ORDER BY c.featured DESC, c.nom ASC - (fr, 1) |
30 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_company_resume.php" |
31 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.website_id AS c__website_id, c.company_id AS c__company_id, c.show_on_homepage AS c__show_on_homepage, c.video AS c__video, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company_portail c WHERE (c.website_id = ? AND c.company_id = ?) - (1, 3402) |
32 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.introduction AS c__introduction, c.missions AS c__missions, c.specialite_company AS c__specialite_company, c.programmes_speciaux AS c__programmes_speciaux, c.clientele AS c__clientele, c.ambiance AS c__ambiance, c.possibilites_carriere AS c__possibilites_carriere, c.temoignages AS c__temoignages, c.processus_embauche AS c__processus_embauche, c.portrait_quartier AS c__portrait_quartier, c.conditions_travail AS c__conditions_travail, c.services_offerts AS c__services_offerts, c.distinctions AS c__distinctions, c.autres_informations AS c__autres_informations, c.lang AS c__lang FROM company_portail_translation c WHERE (c.id IN (?)) - (5178) |
33 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_company_resume.php" |
34 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.website_id AS c__website_id, c.company_id AS c__company_id, c.show_on_homepage AS c__show_on_homepage, c.video AS c__video, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company_portail c WHERE (c.website_id = ? AND c.company_id = ?) - (1, 2087) |
35 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.introduction AS c__introduction, c.missions AS c__missions, c.specialite_company AS c__specialite_company, c.programmes_speciaux AS c__programmes_speciaux, c.clientele AS c__clientele, c.ambiance AS c__ambiance, c.possibilites_carriere AS c__possibilites_carriere, c.temoignages AS c__temoignages, c.processus_embauche AS c__processus_embauche, c.portrait_quartier AS c__portrait_quartier, c.conditions_travail AS c__conditions_travail, c.services_offerts AS c__services_offerts, c.distinctions AS c__distinctions, c.autres_informations AS c__autres_informations, c.lang AS c__lang FROM company_portail_translation c WHERE (c.id IN (?)) - (2930) |
36 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_company_resume.php" |
37 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.website_id AS c__website_id, c.company_id AS c__company_id, c.show_on_homepage AS c__show_on_homepage, c.video AS c__video, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company_portail c WHERE (c.website_id = ? AND c.company_id = ?) - (1, 2331) |
38 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.introduction AS c__introduction, c.missions AS c__missions, c.specialite_company AS c__specialite_company, c.programmes_speciaux AS c__programmes_speciaux, c.clientele AS c__clientele, c.ambiance AS c__ambiance, c.possibilites_carriere AS c__possibilites_carriere, c.temoignages AS c__temoignages, c.processus_embauche AS c__processus_embauche, c.portrait_quartier AS c__portrait_quartier, c.conditions_travail AS c__conditions_travail, c.services_offerts AS c__services_offerts, c.distinctions AS c__distinctions, c.autres_informations AS c__autres_informations, c.lang AS c__lang FROM company_portail_translation c WHERE (c.id IN (?)) - (3341) |
39 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_company_resume.php" |
40 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.website_id AS c__website_id, c.company_id AS c__company_id, c.show_on_homepage AS c__show_on_homepage, c.video AS c__video, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company_portail c WHERE (c.website_id = ? AND c.company_id = ?) - (1, 1354) |
41 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.introduction AS c__introduction, c.missions AS c__missions, c.specialite_company AS c__specialite_company, c.programmes_speciaux AS c__programmes_speciaux, c.clientele AS c__clientele, c.ambiance AS c__ambiance, c.possibilites_carriere AS c__possibilites_carriere, c.temoignages AS c__temoignages, c.processus_embauche AS c__processus_embauche, c.portrait_quartier AS c__portrait_quartier, c.conditions_travail AS c__conditions_travail, c.services_offerts AS c__services_offerts, c.distinctions AS c__distinctions, c.autres_informations AS c__autres_informations, c.lang AS c__lang FROM company_portail_translation c WHERE (c.id IN (?)) - (1647) |
42 | sfPartialView | Render "sf_app_dir/modules/employeurs/templates/_company_resume.php" |
43 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.website_id AS c__website_id, c.company_id AS c__company_id, c.show_on_homepage AS c__show_on_homepage, c.video AS c__video, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM company_portail c WHERE (c.website_id = ? AND c.company_id = ?) - (1, 1362) |
44 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.introduction AS c__introduction, c.missions AS c__missions, c.specialite_company AS c__specialite_company, c.programmes_speciaux AS c__programmes_speciaux, c.clientele AS c__clientele, c.ambiance AS c__ambiance, c.possibilites_carriere AS c__possibilites_carriere, c.temoignages AS c__temoignages, c.processus_embauche AS c__processus_embauche, c.portrait_quartier AS c__portrait_quartier, c.conditions_travail AS c__conditions_travail, c.services_offerts AS c__services_offerts, c.distinctions AS c__distinctions, c.autres_informations AS c__autres_informations, c.lang AS c__lang FROM company_portail_translation c WHERE (c.id IN (?)) - (1664) |
45 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
46 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
47 | main | Call "page->executeTitle()" |
48 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
49 | sfPartialView | Render "sf_app_dir/modules/page/templates/_title.php" |
50 | main | Get slot "og_tags" |
51 | main | Call "pub->executeDfpHeadTag()" |
52 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
53 | main | Call "pub->executeDfpHeadTag()" |
54 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
55 | main | Call "page->executeFacebookInitScript()" |
56 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
57 | sfPartialView | Render "sf_app_dir/modules/page/templates/_facebookInitScript.php" |
58 | main | Call "page->executeMenu()" |
59 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, haut) |
60 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
61 | main | Call "page->executeSocialIcons()" |
62 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
63 | sfPartialView | Render "sf_app_dir/modules/page/templates/_socialIcons.php" |
64 | main | Call "page->executeMenu()" |
65 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, navigation_principale) |
66 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
67 | main | Call "offres->executeSearchBar()" |
68 | sfPartialView | Render "sf_app_dir/modules/offres/templates/_searchBar.php" |
69 | main | Call "pub->executeLeaderboard()" |
70 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
71 | main | Get slot "sidebar-left" |
72 | main | Call "page->executeMenu()" |
73 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_gauche) |
74 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
75 | main | Call "page->executeMenu()" |
76 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_milieu) |
77 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
78 | main | Call "page->executeMenu()" |
79 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_droite) |
80 | sfPartialView | Render "sf_app_dir/modules/page/templates/_menu.php" |
81 | main | Call "page->executeAnalytics()" |
82 | Doctrine_Connection_Statement | execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1) |
83 | sfPartialView | Render "sf_app_dir/modules/page/templates/_analytics.php" |
84 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
85 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |