-
SET NAMES 'utf8mb4'
time: 0.000 sec, slow: NO
-
SELECT generalv2_typecontrat.id, generalv2_typecontrat.duree_determinee, generalv2_typecontrat.ordre, generalv2_typecontrat.isstage, generalv2_typecontrat.isalternance, generalv2_typecontrat.isvie, generalv2_typecontrat.isentrepreneur, generalv2_typecontrat.isinterim, generalv2_typecontrat.isservicecivique, generalv2_typecontrat.isbenevolat, generalv2_typecontrat.entrant_ej, generalv2_typecontrati18n.id, generalv2_typecontrati18n.culture, generalv2_typecontrati18n.value FROM `generalv2_typecontrat` LEFT JOIN `generalv2_typecontrati18n` ON (generalv2_typecontrat.id=generalv2_typecontrati18n.id AND generalv2_typecontrati18n.culture = 'fr') WHERE generalv2_typecontrat.id=3 ORDER BY generalv2_typecontrat.ordre ASC LIMIT 1
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` = 5
time: 0.004 sec, slow: NO
-
SELECT generalv2_labelejentreprise.label_id, generalv2_labelejentreprise.client_id, generalv2_labelejentreprise.distinction, generalv2_labelejentreprise.best, generalv2_labelejentreprise.pme, 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_labelejentreprise` INNER JOIN `generalv2_labelej` ON (generalv2_labelejentreprise.label_id=generalv2_labelej.id) WHERE generalv2_labelejentreprise.client_id=5 AND generalv2_labelej.active=1 ORDER BY generalv2_labelej.annee DESC 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` LEFT JOIN `generalv2_clientbannieremetier` ON (generalv2_clientbanniere.id=generalv2_clientbannieremetier.clientbanniere_id) WHERE generalv2_clientbanniere.client_id=5 AND generalv2_clientbanniere.page_presentation_offres=1 AND generalv2_clientbannieremetier.domaine_id=19
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` LEFT JOIN `generalv2_clientbannieremetier` ON (generalv2_clientbanniere.id=generalv2_clientbannieremetier.clientbanniere_id) WHERE generalv2_clientbanniere.client_id=5 AND generalv2_clientbanniere.page_presentation_offres=1 AND generalv2_clientbannieremetier.domaine_id IS NULL
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=5 AND generalv2_clientbanniere.page_presentation_client=1
time: 0.000 sec, slow: NO
-
SELECT 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` WHERE generalv2_client.client_id=5
time: 0.000 sec, slow: NO
-
SELECT COUNT(*) FROM `generalv2_clientverbatimtellus` WHERE generalv2_clientverbatimtellus.client_id=5 AND generalv2_clientverbatimtellus.selectionnne=1
time: 0.003 sec, slow: NO
-
SELECT `id`, `default_value`, `code`, `dept_libelle`, `region_libelle`, `cacher` FROM `geo_pays` WHERE `id` = 15
time: 0.000 sec, slow: NO
-
SELECT `id`, `pays_id`, `code`, `libelle`, `region_id` FROM `geo_departement` WHERE `id` = 3793
time: 0.000 sec, slow: NO
-
SELECT generalv2_niveaudiplome.id, generalv2_niveaudiplome.niveau, generalv2_niveaudiplome.isced, generalv2_niveaudiplome.ordre, generalv2_niveaudiplome.afficher_dans_cv, generalv2_niveaudiplomei18n.id, generalv2_niveaudiplomei18n.culture, generalv2_niveaudiplomei18n.value, generalv2_niveaudiplomei18n.value_courte FROM `generalv2_niveaudiplome` LEFT JOIN `generalv2_niveaudiplomei18n` ON (generalv2_niveaudiplome.id=generalv2_niveaudiplomei18n.id AND generalv2_niveaudiplomei18n.culture = 'fr') WHERE generalv2_niveaudiplome.id=6 ORDER BY generalv2_niveaudiplome.ordre ASC LIMIT 1
time: 0.006 sec, slow: NO
-
SELECT `id`, `pays_id`, `libelle` FROM `geo_region` WHERE `id` = 125
time: 0.002 sec, slow: NO
-
SELECT geo_pays.id, geo_pays.default_value, geo_pays.code, geo_pays.dept_libelle, geo_pays.region_libelle, geo_pays.cacher, geo_paysi18n.id, geo_paysi18n.culture, geo_paysi18n.value FROM `geo_pays` LEFT JOIN `geo_paysi18n` ON (geo_pays.id=geo_paysi18n.id AND geo_paysi18n.culture = 'fr') WHERE geo_pays.id=15 ORDER BY geo_paysi18n.value ASC LIMIT 1
time: 0.003 sec, slow: NO
-
SELECT `id`, `pourcentage`, `ordre` FROM `generalv2_tauxemploi` WHERE `id` = 1
time: 0.000 sec, slow: NO
-
SELECT generalv2_postelangue.id, generalv2_postelangue.poste_id, generalv2_postelangue.langue_id, generalv2_postelangue.niveau_id, generalv2_postelangue.ordre, generalv2_langue.id, generalv2_langue.iso_639, generalv2_langue.utilisations, generalv2_langue.ordre, generalv2_niveaulangue.id, generalv2_niveaulangue.niveau, generalv2_niveaulangue.ordre, generalv2_languei18n.id, generalv2_languei18n.culture, generalv2_languei18n.value, generalv2_niveaulanguei18n.id, generalv2_niveaulanguei18n.culture, generalv2_niveaulanguei18n.value, generalv2_niveaulanguei18n.cecr FROM `generalv2_postelangue` INNER JOIN `generalv2_langue` ON (generalv2_postelangue.langue_id=generalv2_langue.id) LEFT JOIN `generalv2_niveaulangue` ON (generalv2_postelangue.niveau_id=generalv2_niveaulangue.id) LEFT JOIN `generalv2_languei18n` ON (generalv2_langue.id=generalv2_languei18n.id AND generalv2_languei18n.culture = 'fr') LEFT JOIN `generalv2_niveaulanguei18n` ON (generalv2_niveaulangue.id=generalv2_niveaulanguei18n.id AND generalv2_niveaulanguei18n.culture = 'fr') WHERE generalv2_postelangue.poste_id=27280842 AND generalv2_langue.iso_639='en' ORDER BY generalv2_langue.ordre ASC,generalv2_niveaulangue.ordre ASC
time: 0.000 sec, slow: NO
-
SELECT generalv2_filiere.id, generalv2_filiere.duree_visibilite_interne, generalv2_filiere.active, generalv2_filiere.backoffice_id, generalv2_filierei18n.id, generalv2_filierei18n.culture, generalv2_filierei18n.libelle, generalv2_filierei18n.description FROM `generalv2_filiere` INNER JOIN `generalv2_postefiliere` ON (generalv2_filiere.id=generalv2_postefiliere.filiere_id) LEFT JOIN `generalv2_filierei18n` ON (generalv2_filiere.id=generalv2_filierei18n.id AND generalv2_filierei18n.culture = 'fr') WHERE (generalv2_postefiliere.poste_id=27280842 AND generalv2_postefiliere.filiere_id=97)
time: 0.000 sec, slow: NO
-
SELECT `id`, `liste_id`, `domaine_parent_id`, `ordre`, `code` FROM `generalv2_domaineprofessionnel` WHERE `id` = 3885
time: 0.000 sec, slow: NO
-
SELECT generalv2_domaineprofessionnel.id, generalv2_domaineprofessionnel.liste_id, generalv2_domaineprofessionnel.domaine_parent_id, generalv2_domaineprofessionnel.ordre, generalv2_domaineprofessionnel.code, generalv2_domaineprofessionneli18n.id, generalv2_domaineprofessionneli18n.culture, generalv2_domaineprofessionneli18n.value FROM `generalv2_domaineprofessionnel` LEFT JOIN `generalv2_domaineprofessionneli18n` ON (generalv2_domaineprofessionnel.id=generalv2_domaineprofessionneli18n.id AND generalv2_domaineprofessionneli18n.culture = 'fr') WHERE generalv2_domaineprofessionnel.id=3788 ORDER BY generalv2_domaineprofessionnel.ordre ASC
time: 0.000 sec, slow: NO
-
SELECT `id`, `culture`, `value` FROM `generalv2_domaineprofessionneli18n` WHERE `id` = 3885 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` = 85
time: 0.000 sec, slow: NO
-
SELECT `id`, `nom`, `societe_publique`, `nombre_employe`, `secteur_activite_id`, `secteur_activite_spec_id`, `client_id`, `societe_id`, `logo100x40`, `logo90x30`, `estleclient`, `logo180x60`, `adresse_id`, `sigle`, `adresse1`, `adresse2`, `code_postal`, `ville`, `site_web`, `prive`, `telephone`, `annee_creation`, `nombre_consultants`, `nombre_charges_recherche`, `nb_missions_an`, `valide`, `date_validation`, `valideur_id` FROM `generalv2_societe` WHERE `id` = 122
time: 0.003 sec, slow: NO
-
SELECT generalv2_clientfiliere.client_id, generalv2_clientfiliere.filiere_id, generalv2_clientfiliere.date_ajout, generalv2_clientfiliere.date_validation, generalv2_clientfiliere.valide, generalv2_clientfiliere.valideur_id, generalv2_clientfiliere.choix_individuel, generalv2_clientfiliere.id FROM `generalv2_clientfiliere` WHERE generalv2_clientfiliere.client_id=5
time: 0.000 sec, slow: NO
-
SELECT generalv2_filiere.id, generalv2_filiere.duree_visibilite_interne, generalv2_filiere.active, generalv2_filiere.backoffice_id FROM `generalv2_filiere` WHERE generalv2_filiere.id IN (10,7,13,85,25,76) LIMIT 4
time: 0.000 sec, slow: NO
-
SELECT `id`, `culture`, `libelle`, `description` FROM `generalv2_filierei18n` WHERE `id` = 7 AND `culture` = 'fr'
time: 0.000 sec, slow: NO
-
SELECT `id`, `culture`, `libelle`, `description` FROM `generalv2_filierei18n` WHERE `id` = 10 AND `culture` = 'fr'
time: 0.000 sec, slow: NO
-
SELECT `id`, `culture`, `libelle`, `description` FROM `generalv2_filierei18n` WHERE `id` = 13 AND `culture` = 'fr'
time: 0.000 sec, slow: NO
-
SELECT `id`, `culture`, `libelle`, `description` FROM `generalv2_filierei18n` WHERE `id` = 25 AND `culture` = 'fr'
time: 0.000 sec, slow: NO
-
SELECT 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` WHERE generalv2_client.client_id=5
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=5 AND generalv2_clientbanniere.page_presentation_client=1
time: 0.004 sec, slow: NO
-
SELECT generalv2_labelejentreprise.label_id, generalv2_labelejentreprise.client_id, generalv2_labelejentreprise.distinction, generalv2_labelejentreprise.best, generalv2_labelejentreprise.pme FROM `generalv2_labelejentreprise` WHERE generalv2_labelejentreprise.best=1 AND generalv2_labelejentreprise.label_id=2
time: 0.002 sec, slow: NO
config
view
logs
120832.0 KB
31
