Query Metrics
7
Database Queries
5
Different statements
190.02 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.59 ms |
SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = 0 AND (s0_.obsolete <> ? OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC
Parameters:
[
"oui"
]
|
| 2 | 10.51 ms |
SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = 0 AND (s0_.obsolete <> ? OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC
Parameters:
[
"oui"
]
|
| 3 | 23.77 ms |
SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = ?
Parameters:
[
"publique"
]
|
| 4 | 23.72 ms |
SELECT DISTINCT a0_.id_repreneur AS id_repreneur_0, a0_.date_parution_initiale AS date_parution_initiale_1, a0_.id_repreneur AS id_repreneur_2 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = ? ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC LIMIT 10 OFFSET 40
Parameters:
[
"publique"
]
|
| 5 | 20.94 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 = ? AND a0_.id_repreneur IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC
Parameters:
[ "publique" 308183 308043 291226 307976 307961 290454 307725 306727 307371 299163 ] |
| 6 | 57.21 ms |
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ?
Parameters:
[
"bb39c19881178602028d5abc212cd7f5"
]
|
| 7 | 43.29 ms |
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ?
Parameters:
[
"6205a50390a5e6364b6d365e0ea89e62"
]
|
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\SecteursActivite | No errors. |
| App\Entity\AnnuaireRepreneurs | No errors. |
| App\Entity\Translation | No errors. |