Query Metrics
6
Database Queries
5
Different statements
126.86 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.83 ms |
SELECT t0.id_repreneur AS id_repreneur_1, t0.login AS login_2, t0.mode_profil AS mode_profil_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.adresse AS adresse_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.id_pays AS id_pays_9, t0.telephone AS telephone_10, t0.indicatif_telephone AS indicatif_telephone_11, t0.email AS email_12, t0.annee_naissance AS annee_naissance_13, t0.description_societe_recherchee AS description_societe_recherchee_14, t0.mots_cles_activite AS mots_cles_activite_15, t0.id_secteur_activite_recherche AS id_secteur_activite_recherche_16, t0.localisations_recherchees AS localisations_recherchees_17, t0.valeur_min_entreprise AS valeur_min_entreprise_18, t0.valeur_max_entreprise AS valeur_max_entreprise_19, t0.montant_apport AS montant_apport_20, t0.formation AS formation_21, t0.parcours_professionnel AS parcours_professionnel_22, t0.competences AS competences_23, t0.competences_recherchees AS competences_recherchees_24, t0.mobile_geographiquement AS mobile_geographiquement_25, t0.commentaires AS commentaires_26, t0.date_mise_a_jour AS date_mise_a_jour_27, t0.visible_annuaire AS visible_annuaire_28, t0.consultable_fp AS consultable_fp_29, t0.consultable_ce AS consultable_ce_30, t0.date_parution AS date_parution_31, t0.date_parution_initiale AS date_parution_initiale_32, t0.date_parution_initiale_complete AS date_parution_initiale_complete_33, t0.relance_mise_a_jour AS relance_mise_a_jour_34, t0.date_relance AS date_relance_35, t0.deja_publique AS deja_publique_36, t0.titre_societe_recherchee AS titre_societe_recherchee_37, t0.id_localisations_recherchees AS id_localisations_recherchees_38, t0.demarche AS demarche_39, t0.complements_demarche AS complements_demarche_40, t0.titre_profil AS titre_profil_41, t0.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_42, t0.publication_newsletter_buzz AS publication_newsletter_buzz_43, t0.mots_cle_recherche AS mots_cle_recherche_44, t0.statut AS statut_45, t0.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_46, t0.etat_annonce_prioritaire AS etat_annonce_prioritaire_47, t0.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_48, t0.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_49, t0.suivi AS suivi_50, t0.is_international AS is_international_51 FROM fusacq_dbo.annuaire_repreneurs t0 WHERE t0.id_repreneur = ? LIMIT 1
Parameters:
[
"214346"
]
|
| 2 | 50.03 ms |
SELECT a0_.id_repreneur AS id_repreneur_0, a0_.login AS login_1, a0_.mode_profil AS mode_profil_2, a0_.nom AS nom_3, a0_.prenom AS prenom_4, a0_.adresse AS adresse_5, a0_.code_postal AS code_postal_6, a0_.ville AS ville_7, a0_.id_pays AS id_pays_8, a0_.telephone AS telephone_9, a0_.indicatif_telephone AS indicatif_telephone_10, a0_.email AS email_11, a0_.annee_naissance AS annee_naissance_12, a0_.description_societe_recherchee AS description_societe_recherchee_13, a0_.mots_cles_activite AS mots_cles_activite_14, a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_15, a0_.localisations_recherchees AS localisations_recherchees_16, a0_.valeur_min_entreprise AS valeur_min_entreprise_17, a0_.valeur_max_entreprise AS valeur_max_entreprise_18, a0_.montant_apport AS montant_apport_19, a0_.formation AS formation_20, a0_.parcours_professionnel AS parcours_professionnel_21, a0_.competences AS competences_22, a0_.competences_recherchees AS competences_recherchees_23, a0_.mobile_geographiquement AS mobile_geographiquement_24, a0_.commentaires AS commentaires_25, a0_.date_mise_a_jour AS date_mise_a_jour_26, a0_.visible_annuaire AS visible_annuaire_27, a0_.consultable_fp AS consultable_fp_28, a0_.consultable_ce AS consultable_ce_29, a0_.date_parution AS date_parution_30, a0_.date_parution_initiale AS date_parution_initiale_31, a0_.date_parution_initiale_complete AS date_parution_initiale_complete_32, a0_.relance_mise_a_jour AS relance_mise_a_jour_33, a0_.date_relance AS date_relance_34, a0_.deja_publique AS deja_publique_35, a0_.titre_societe_recherchee AS titre_societe_recherchee_36, a0_.id_localisations_recherchees AS id_localisations_recherchees_37, a0_.demarche AS demarche_38, a0_.complements_demarche AS complements_demarche_39, a0_.titre_profil AS titre_profil_40, a0_.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_41, a0_.publication_newsletter_buzz AS publication_newsletter_buzz_42, a0_.mots_cle_recherche AS mots_cle_recherche_43, a0_.statut AS statut_44, a0_.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_45, a0_.etat_annonce_prioritaire AS etat_annonce_prioritaire_46, a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_47, a0_.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_48, a0_.suivi AS suivi_49, a0_.is_international AS is_international_50 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = ? ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC LIMIT 1 OFFSET 3
Parameters:
[
"publique"
]
|
| 3 | 35.52 ms |
SELECT a0_.id_repreneur AS id_repreneur_0, a0_.login AS login_1, a0_.mode_profil AS mode_profil_2, a0_.nom AS nom_3, a0_.prenom AS prenom_4, a0_.adresse AS adresse_5, a0_.code_postal AS code_postal_6, a0_.ville AS ville_7, a0_.id_pays AS id_pays_8, a0_.telephone AS telephone_9, a0_.indicatif_telephone AS indicatif_telephone_10, a0_.email AS email_11, a0_.annee_naissance AS annee_naissance_12, a0_.description_societe_recherchee AS description_societe_recherchee_13, a0_.mots_cles_activite AS mots_cles_activite_14, a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_15, a0_.localisations_recherchees AS localisations_recherchees_16, a0_.valeur_min_entreprise AS valeur_min_entreprise_17, a0_.valeur_max_entreprise AS valeur_max_entreprise_18, a0_.montant_apport AS montant_apport_19, a0_.formation AS formation_20, a0_.parcours_professionnel AS parcours_professionnel_21, a0_.competences AS competences_22, a0_.competences_recherchees AS competences_recherchees_23, a0_.mobile_geographiquement AS mobile_geographiquement_24, a0_.commentaires AS commentaires_25, a0_.date_mise_a_jour AS date_mise_a_jour_26, a0_.visible_annuaire AS visible_annuaire_27, a0_.consultable_fp AS consultable_fp_28, a0_.consultable_ce AS consultable_ce_29, a0_.date_parution AS date_parution_30, a0_.date_parution_initiale AS date_parution_initiale_31, a0_.date_parution_initiale_complete AS date_parution_initiale_complete_32, a0_.relance_mise_a_jour AS relance_mise_a_jour_33, a0_.date_relance AS date_relance_34, a0_.deja_publique AS deja_publique_35, a0_.titre_societe_recherchee AS titre_societe_recherchee_36, a0_.id_localisations_recherchees AS id_localisations_recherchees_37, a0_.demarche AS demarche_38, a0_.complements_demarche AS complements_demarche_39, a0_.titre_profil AS titre_profil_40, a0_.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_41, a0_.publication_newsletter_buzz AS publication_newsletter_buzz_42, a0_.mots_cle_recherche AS mots_cle_recherche_43, a0_.statut AS statut_44, a0_.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_45, a0_.etat_annonce_prioritaire AS etat_annonce_prioritaire_46, a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_47, a0_.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_48, a0_.suivi AS suivi_49, a0_.is_international AS is_international_50 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = ? ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC LIMIT 1 OFFSET 5
Parameters:
[
"publique"
]
|
| 4 | 10.22 ms |
SELECT a0_.id_repreneur AS id_repreneur_0, a0_.date_parution AS date_parution_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.nom AS nom_3, a0_.prenom AS prenom_4, a0_.adresse AS adresse_5, a0_.code_postal AS code_postal_6, a0_.telephone AS telephone_7, a0_.indicatif_telephone AS indicatif_telephone_8, a0_.email AS email_9, a0_.ville AS ville_10, a0_.id_pays AS id_pays_11, a0_.description_societe_recherchee AS description_societe_recherchee_12, a0_.annee_naissance AS annee_naissance_13, a0_.formation AS formation_14, a0_.parcours_professionnel AS parcours_professionnel_15, a0_.competences_recherchees AS competences_recherchees_16, a0_.competences AS competences_17, a0_.titre_societe_recherchee AS titre_societe_recherchee_18, a0_.id_localisations_recherchees AS id_localisations_recherchees_19, a0_.valeur_max_entreprise AS valeur_max_entreprise_20, a0_.valeur_min_entreprise AS valeur_min_entreprise_21, a0_.montant_apport AS montant_apport_22, a0_.demarche AS demarche_23, a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_24, a0_.mots_cles_activite AS mots_cles_activite_25, a0_.complements_demarche AS complements_demarche_26, a0_.mots_cle_recherche AS mots_cle_recherche_27, a0_.mode_profil AS mode_profil_28 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.id_repreneur = ? LIMIT 1
Parameters:
[
214346
]
|
| 5 | 10.04 ms |
SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1
Parameters:
[
"302"
]
|
| 6 | 10.23 ms |
SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1
Parameters:
[
"3"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AnnuaireRepreneurs | No errors. |
| App\Entity\SecteursActivite | No errors. |
| App\Entity\Translation | No errors. |