-
SET NAMES 'utf8mb4'
time: 0.000 sec, slow: NO
-
SELECT generalv2_clientpagecommunicationitem.id, generalv2_clientpagecommunicationitem.client_id, generalv2_clientpagecommunicationitem.version_id, generalv2_clientpagecommunicationitem.code_onglet, generalv2_clientpagecommunicationitem.code_agencement, generalv2_clientpagecommunicationitem.ordre, generalv2_clientpagecommunicationitem.date_creation, generalv2_clientpagecommunicationitem.date_modification, generalv2_clientpagecommunicationitemi18n.id, generalv2_clientpagecommunicationitemi18n.culture, generalv2_clientpagecommunicationitemi18n.titre, generalv2_clientpagecommunicationitemcontent.id, generalv2_clientpagecommunicationitemcontent.item_id, generalv2_clientpagecommunicationitemcontent.position_illustration, generalv2_clientpagecommunicationitemcontent.url_lien, generalv2_clientpagecommunicationitemcontent.url_image, generalv2_clientpagecommunicationitemcontent.url_image_mail, generalv2_clientpagecommunicationitemcontent.url_image_rs, generalv2_clientpagecommunicationitemcontent.url_video, generalv2_clientpagecommunicationitemcontent.url_video_preview, generalv2_clientpagecommunicationitemcontent.code_video, generalv2_clientpagecommunicationitemcontent.carousel_id, generalv2_clientpagecommunicationitemcontent.stat_panel_id, generalv2_clientpagecommunicationitemcontent.ordre, generalv2_clientpagecommunicationitemcontent.chevron_agrandissement, generalv2_clientpagecommunicationitemcontent.date_creation, generalv2_clientpagecommunicationitemcontent.date_modification, generalv2_clientpagecommunicationitemcontent.date_debut_publication, generalv2_clientpagecommunicationitemcontent.date_fin_publication, generalv2_clientpagecommunicationitemcontenti18n.id, generalv2_clientpagecommunicationitemcontenti18n.culture, generalv2_clientpagecommunicationitemcontenti18n.titre, generalv2_clientpagecommunicationitemcontenti18n.content, generalv2_clientpagecommunicationitemcontenti18n.titre_lien, generalv2_clientpagecommunicationitemcontenti18n.legende_illustration FROM `generalv2_clientpagecommunicationitem` LEFT JOIN `generalv2_clientpagecommunicationitemi18n` ON (generalv2_clientpagecommunicationitem.id=generalv2_clientpagecommunicationitemi18n.id AND generalv2_clientpagecommunicationitemi18n.culture = 'fr') INNER JOIN `generalv2_clientpagecommunicationversion` ON (generalv2_clientpagecommunicationitem.version_id=generalv2_clientpagecommunicationversion.id) LEFT JOIN `generalv2_clientpagecommunicationitemcontent` ON (generalv2_clientpagecommunicationitem.id=generalv2_clientpagecommunicationitemcontent.item_id) LEFT JOIN `generalv2_clientpagecommunicationitemcontenti18n` ON (generalv2_clientpagecommunicationitemcontent.id=generalv2_clientpagecommunicationitemcontenti18n.id AND generalv2_clientpagecommunicationitemcontenti18n.culture = 'fr') WHERE generalv2_clientpagecommunicationitem.code_onglet IN ('ACTU','ACTU_ECOLE') AND generalv2_clientpagecommunicationversion.version=0 AND (generalv2_clientpagecommunicationitemcontent.date_debut_publication<='2026-03-28 21:17:48' OR generalv2_clientpagecommunicationitemcontent.date_debut_publication IS NULL ) AND (generalv2_clientpagecommunicationitemcontent.date_fin_publication>='2026-03-28 21:17:48' OR generalv2_clientpagecommunicationitemcontent.date_fin_publication IS NULL ) ORDER BY IFNULL(generalv2_clientpagecommunicationitemcontent.date_debut_publication, generalv2_clientpagecommunicationitemcontent.date_creation) DESC
time: 0.009 sec, slow: NO
-
SELECT `id`, `nom`, `siret`, `site_web`, `email`, `adresse1`, `adresse2`, `ville_id`, `telephone`, `fax`, `code_retour_cv`, `active`, `backoffice_id`, `date_creation`, `date_derniere_modif`, `date_activation`, `date_cloture`, `code_postal`, `ville`, `secteur_activite_id`, `lien_suivi_deploiement`, `souhait_acces_cvtheque`, `souhait_depot_offres`, `souhait_depot_candidats`, `source_inscription`, `temps_visible_interne`, `client_id`, `modules_ouverts`, `type_client`, `profil_saisi`, `onisep_id`, `pas_interesse_par_ej`, `rappeler_le`, `rappeler_a_partir_du`, `url_logo`, `ratio_logo`, `url_logo_mail`, `url_logo_rs`, `cvtheque_tuteur` FROM `generalv2_client` WHERE `id` = 691
time: 0.000 sec, slow: NO
-
SELECT `id`, `nom`, `siret`, `site_web`, `email`, `adresse1`, `adresse2`, `ville_id`, `telephone`, `fax`, `code_retour_cv`, `active`, `backoffice_id`, `date_creation`, `date_derniere_modif`, `date_activation`, `date_cloture`, `code_postal`, `ville`, `secteur_activite_id`, `lien_suivi_deploiement`, `souhait_acces_cvtheque`, `souhait_depot_offres`, `souhait_depot_candidats`, `source_inscription`, `temps_visible_interne`, `client_id`, `modules_ouverts`, `type_client`, `profil_saisi`, `onisep_id`, `pas_interesse_par_ej`, `rappeler_le`, `rappeler_a_partir_du`, `url_logo`, `ratio_logo`, `url_logo_mail`, `url_logo_rs`, `cvtheque_tuteur` FROM `generalv2_client` WHERE `id` = 695
time: 0.000 sec, slow: NO
-
SELECT COUNT(*) FROM `generalv2_client` WHERE generalv2_client.active=1 AND generalv2_client.backoffice_id=4
time: 0.002 sec, slow: NO
-
SELECT COUNT(*) FROM `generalv2_backofficeuser` LEFT JOIN `generalv2_client` ON (generalv2_backofficeuser.client_id=generalv2_client.id) WHERE generalv2_backofficeuser.active=1 AND generalv2_backofficeuser.droits&2 AND generalv2_client.active=1 AND generalv2_client.backoffice_id=4
time: 0.000 sec, slow: NO
-
SELECT generalv2_labelformation.id, generalv2_labelformation.annee, generalv2_labelformation.url_logo_reseaux_sociaux, generalv2_labelformation.url_logo, generalv2_labelformation.url_logo_carre, generalv2_labelformation.url_trophee, generalv2_labelformation.url_trophee_detail, generalv2_labelformation.url_decoration_page_label, generalv2_labelformation.couleur_dominante, generalv2_labelformation.active, generalv2_labelformation.date_modification, generalv2_labelformation.url_kit_communication FROM `generalv2_labelformation` WHERE generalv2_labelformation.active=1 ORDER BY generalv2_labelformation.annee DESC LIMIT 1
time: 0.000 sec, slow: NO
-
SELECT COUNT(*) FROM (SELECT DISTINCT generalv2_ecoleformation.id, generalv2_ecoleformation.ecole_id, generalv2_ecoleformation.niveau_diplome_sortie_id, generalv2_ecoleformation.intitule_diplome_id, generalv2_ecoleformation.date_limite_reception_dossiers, generalv2_ecoleformation.site_web, generalv2_ecoleformation.places_disponibles, generalv2_ecoleformation.places_disponibles_date_maj, generalv2_ecoleformation.reconnaissance_rncp, generalv2_ecoleformation.formations_initiale, generalv2_ecoleformation.formations_continue, generalv2_ecoleformation.vae, generalv2_ecoleformation.stage, generalv2_ecoleformation.alternance, generalv2_ecoleformation.cout_alternance, generalv2_ecoleformation.contrat_professionnalisation, generalv2_ecoleformation.cout_contrat_professionnalisation, generalv2_ecoleformation.stage_temps_partiel, generalv2_ecoleformation.cours_du_soir, generalv2_ecoleformation.cours_a_distance, generalv2_ecoleformation.organisme_gestionnaire_id, generalv2_ecoleformation.onisep_id FROM `generalv2_ecoleformation` LEFT JOIN `generalv2_intitulediplome` ON (generalv2_ecoleformation.intitule_diplome_id=generalv2_intitulediplome.id) LEFT JOIN `generalv2_intitulediplomei18n` ON (generalv2_intitulediplome.id=generalv2_intitulediplomei18n.id AND generalv2_intitulediplomei18n.culture = 'fr') LEFT JOIN `generalv2_ecoleformationi18n` ON (generalv2_ecoleformation.id=generalv2_ecoleformationi18n.id AND generalv2_ecoleformationi18n.culture = 'fr') INNER JOIN `generalv2_formationlabellisee` ON (generalv2_ecoleformation.id=generalv2_formationlabellisee.formation_id) WHERE generalv2_formationlabellisee.labellisation=1 AND generalv2_formationlabellisee.date_labellisation>='2025-03-28 21:17:48') propelmatch4cnt
time: 0.000 sec, slow: NO
-
SELECT generalv2_labelej.id, generalv2_labelej.annee, generalv2_labelej.url_logo_reseaux_sociaux, generalv2_labelej.url_logo_entreprise_choix, generalv2_labelej.url_logo_bestinclass, generalv2_labelej.url_logo_carre_entreprise_choix, generalv2_labelej.url_logo_carre_bestinclass, generalv2_labelej.url_logo_trophee_entreprise_choix, generalv2_labelej.url_trophee, generalv2_labelej.url_trophee_detail, generalv2_labelej.couleur_dominante_entreprise_choix, generalv2_labelej.couleur_dominante_bestinclass, generalv2_labelej.active, generalv2_labelej.date_modification FROM `generalv2_labelej` WHERE generalv2_labelej.active=1 ORDER BY generalv2_labelej.annee DESC LIMIT 1
time: 0.000 sec, slow: NO
-
SELECT COUNT(*) FROM (SELECT DISTINCT generalv2_client.id, generalv2_client.nom, generalv2_client.siret, generalv2_client.site_web, generalv2_client.email, generalv2_client.adresse1, generalv2_client.adresse2, generalv2_client.ville_id, generalv2_client.telephone, generalv2_client.fax, generalv2_client.code_retour_cv, generalv2_client.active, generalv2_client.backoffice_id, generalv2_client.date_creation, generalv2_client.date_derniere_modif, generalv2_client.date_activation, generalv2_client.date_cloture, generalv2_client.code_postal, generalv2_client.ville, generalv2_client.secteur_activite_id, generalv2_client.lien_suivi_deploiement, generalv2_client.souhait_acces_cvtheque, generalv2_client.souhait_depot_offres, generalv2_client.souhait_depot_candidats, generalv2_client.source_inscription, generalv2_client.temps_visible_interne, generalv2_client.client_id, generalv2_client.modules_ouverts, generalv2_client.type_client, generalv2_client.profil_saisi, generalv2_client.onisep_id, generalv2_client.pas_interesse_par_ej, generalv2_client.rappeler_le, generalv2_client.rappeler_a_partir_du, generalv2_client.url_logo, generalv2_client.ratio_logo, generalv2_client.url_logo_mail, generalv2_client.url_logo_rs, generalv2_client.cvtheque_tuteur FROM `generalv2_client` LEFT JOIN `generalv2_labelejentreprise` ON (generalv2_client.id=generalv2_labelejentreprise.client_id) LEFT JOIN `generalv2_societe` ON (generalv2_client.id=generalv2_societe.client_id) LEFT JOIN `generalv2_societei18n` ON (generalv2_societe.id=generalv2_societei18n.id AND generalv2_societei18n.culture = 'fr') WHERE generalv2_client.backoffice_id=4 AND generalv2_labelejentreprise.label_id=17 AND generalv2_labelejentreprise.pme=0 AND generalv2_societe.estleclient=1) propelmatch4cnt
time: 0.001 sec, slow: NO
-
SELECT generalv2_societe.id, generalv2_societe.nom, generalv2_societe.societe_publique, generalv2_societe.nombre_employe, generalv2_societe.secteur_activite_id, generalv2_societe.secteur_activite_spec_id, generalv2_societe.client_id, generalv2_societe.societe_id, generalv2_societe.logo100x40, generalv2_societe.logo90x30, generalv2_societe.estleclient, generalv2_societe.logo180x60, generalv2_societe.adresse_id, generalv2_societe.sigle, generalv2_societe.adresse1, generalv2_societe.adresse2, generalv2_societe.code_postal, generalv2_societe.ville, generalv2_societe.site_web, generalv2_societe.prive, generalv2_societe.telephone, generalv2_societe.annee_creation, generalv2_societe.nombre_consultants, generalv2_societe.nombre_charges_recherche, generalv2_societe.nb_missions_an, generalv2_societe.valide, generalv2_societe.date_validation, generalv2_societe.valideur_id FROM `generalv2_societe` WHERE generalv2_societe.client_id=691 AND generalv2_societe.estleclient=1 LIMIT 1
time: 0.000 sec, slow: NO
-
SELECT generalv2_ecole.id, generalv2_ecole.ville_id, generalv2_ecole.type_ecole_id, generalv2_ecole.sigle, generalv2_ecole.show_in_list, generalv2_ecole.client_id, generalv2_ecole.adresse1, generalv2_ecole.adresse2, generalv2_ecole.code_postal, generalv2_ecole.ville, generalv2_ecole.site_web, generalv2_ecole.prive, generalv2_ecole.laboratoires, generalv2_ecole.laboratoires_detail, generalv2_ecole.associations, generalv2_ecole.associations_detail, generalv2_ecole.jee, generalv2_ecole.contact_jee, generalv2_ecole.telephone, generalv2_ecole.cvtheque_dotee FROM `generalv2_ecole` WHERE generalv2_ecole.client_id=691 LIMIT 1
time: 0.000 sec, slow: NO
-
SELECT `id`, `culture`, `nom`, `presentation`, `libelle_plaquette`, `url_plaquette` FROM `generalv2_ecolei18n` WHERE `id` = 22 AND `culture` = 'fr'
time: 0.000 sec, slow: NO
-
SELECT `id`, `nom`, `siret`, `site_web`, `email`, `adresse1`, `adresse2`, `ville_id`, `telephone`, `fax`, `code_retour_cv`, `active`, `backoffice_id`, `date_creation`, `date_derniere_modif`, `date_activation`, `date_cloture`, `code_postal`, `ville`, `secteur_activite_id`, `lien_suivi_deploiement`, `souhait_acces_cvtheque`, `souhait_depot_offres`, `souhait_depot_candidats`, `source_inscription`, `temps_visible_interne`, `client_id`, `modules_ouverts`, `type_client`, `profil_saisi`, `onisep_id`, `pas_interesse_par_ej`, `rappeler_le`, `rappeler_a_partir_du`, `url_logo`, `ratio_logo`, `url_logo_mail`, `url_logo_rs`, `cvtheque_tuteur` FROM `generalv2_client` WHERE `id` = 687
time: 0.000 sec, slow: NO
-
SELECT generalv2_societe.id, generalv2_societe.nom, generalv2_societe.societe_publique, generalv2_societe.nombre_employe, generalv2_societe.secteur_activite_id, generalv2_societe.secteur_activite_spec_id, generalv2_societe.client_id, generalv2_societe.societe_id, generalv2_societe.logo100x40, generalv2_societe.logo90x30, generalv2_societe.estleclient, generalv2_societe.logo180x60, generalv2_societe.adresse_id, generalv2_societe.sigle, generalv2_societe.adresse1, generalv2_societe.adresse2, generalv2_societe.code_postal, generalv2_societe.ville, generalv2_societe.site_web, generalv2_societe.prive, generalv2_societe.telephone, generalv2_societe.annee_creation, generalv2_societe.nombre_consultants, generalv2_societe.nombre_charges_recherche, generalv2_societe.nb_missions_an, generalv2_societe.valide, generalv2_societe.date_validation, generalv2_societe.valideur_id FROM `generalv2_societe` WHERE generalv2_societe.client_id=687 AND generalv2_societe.estleclient=1 LIMIT 1
time: 0.000 sec, slow: NO
-
SELECT generalv2_clientbanniere.id, generalv2_clientbanniere.client_id, generalv2_clientbanniere.url_banniere, generalv2_clientbanniere.page_presentation_client, generalv2_clientbanniere.page_presentation_offres FROM `generalv2_clientbanniere` WHERE generalv2_clientbanniere.client_id=691 AND generalv2_clientbanniere.page_presentation_client=1
time: 0.000 sec, slow: NO
-
SELECT generalv2_societe.id, generalv2_societe.nom, generalv2_societe.societe_publique, generalv2_societe.nombre_employe, generalv2_societe.secteur_activite_id, generalv2_societe.secteur_activite_spec_id, generalv2_societe.client_id, generalv2_societe.societe_id, generalv2_societe.logo100x40, generalv2_societe.logo90x30, generalv2_societe.estleclient, generalv2_societe.logo180x60, generalv2_societe.adresse_id, generalv2_societe.sigle, generalv2_societe.adresse1, generalv2_societe.adresse2, generalv2_societe.code_postal, generalv2_societe.ville, generalv2_societe.site_web, generalv2_societe.prive, generalv2_societe.telephone, generalv2_societe.annee_creation, generalv2_societe.nombre_consultants, generalv2_societe.nombre_charges_recherche, generalv2_societe.nb_missions_an, generalv2_societe.valide, generalv2_societe.date_validation, generalv2_societe.valideur_id FROM `generalv2_societe` WHERE generalv2_societe.client_id=695 AND generalv2_societe.estleclient=1 LIMIT 1
time: 0.000 sec, slow: NO
-
SELECT generalv2_ecole.id, generalv2_ecole.ville_id, generalv2_ecole.type_ecole_id, generalv2_ecole.sigle, generalv2_ecole.show_in_list, generalv2_ecole.client_id, generalv2_ecole.adresse1, generalv2_ecole.adresse2, generalv2_ecole.code_postal, generalv2_ecole.ville, generalv2_ecole.site_web, generalv2_ecole.prive, generalv2_ecole.laboratoires, generalv2_ecole.laboratoires_detail, generalv2_ecole.associations, generalv2_ecole.associations_detail, generalv2_ecole.jee, generalv2_ecole.contact_jee, generalv2_ecole.telephone, generalv2_ecole.cvtheque_dotee FROM `generalv2_ecole` WHERE generalv2_ecole.client_id=695 LIMIT 1
time: 0.000 sec, slow: NO
-
SELECT `id`, `culture`, `nom`, `presentation`, `libelle_plaquette`, `url_plaquette` FROM `generalv2_ecolei18n` WHERE `id` = 26 AND `culture` = 'fr'
time: 0.000 sec, slow: NO
-
SELECT generalv2_clientbanniere.id, generalv2_clientbanniere.client_id, generalv2_clientbanniere.url_banniere, generalv2_clientbanniere.page_presentation_client, generalv2_clientbanniere.page_presentation_offres FROM `generalv2_clientbanniere` WHERE generalv2_clientbanniere.client_id=695 AND generalv2_clientbanniere.page_presentation_client=1
time: 0.000 sec, slow: NO