Query Metrics
7
Database Queries
5
Different statements
74.35 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.98 ms |
SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.login_utilisateur AS login_utilisateur_4, a0_.date_parution_elite AS date_parution_elite_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12, a0_.mode_annonce AS mode_annonce_13, a0_.id_raison_cession AS id_raison_cession_14, a0_.date_creation_societe AS date_creation_societe_15, a0_.type_cession AS type_cession_16, a0_.description_activite AS description_activite_17, a0_.possession_brevets AS possession_brevets_18, a0_.possession_marques AS possession_marques_19, a0_.travail_export AS travail_export_20, a0_.raison_cession AS raison_cession_21, a0_.annee_n AS annee_n_22, a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23, a0_.ca_nmoinsun AS ca_nmoinsun_24, a0_.ca_nplusun AS ca_nplusun_25, a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26, a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27, a0_.marge_brute_n AS marge_brute_n_28, a0_.marge_brute_nplusun AS marge_brute_nplusun_29, a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30, a0_.EBE_nmoinsun AS EBE_nmoinsun_31, a0_.EBE_n AS EBE_n_32, a0_.EBE_nplusun AS EBE_nplusun_33, a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34, a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35, a0_.resultat_exploitation_n AS resultat_exploitation_n_36, a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37, a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38, a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39, a0_.resultat_net_n AS resultat_net_n_40, a0_.resultat_net_nplusun AS resultat_net_nplusun_41, a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42, a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43, a0_.nb_personnes_n AS nb_personnes_n_44, a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45, a0_.fonds_propres AS fonds_propres_46, a0_.dettes_financieres AS dettes_financieres_47, a0_.tresorerie_nette AS tresorerie_nette_48, a0_.points_forts AS points_forts_49, a0_.points_faibles AS points_faibles_50, a0_.positionnement_marche AS positionnement_marche_51, a0_.concurrence AS concurrence_52, a0_.prix_cession AS prix_cession_53, a0_.redressement_judiciaire AS redressement_judiciaire_54, a0_.apport_fp_min AS apport_fp_min_55, a0_.recherche_active AS recherche_active_56, a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57, a0_.elements_complementaires AS elements_complementaires_58, a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59, a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60, a0_.nom_contact AS nom_contact_61, a0_.email AS email_62, a0_.telephone AS telephone_63, a0_.commentaires AS commentaires_64, a0_.endettement_net_n AS endettement_net_n_65, a0_.id_langue AS id_langue_66, a0_.indicatif_telephone AS indicatif_telephone_67, a0_.date_fin_publique_elite AS date_fin_publique_elite_68 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_vendeur = 30893
Parameters:
[] |
| 2 | 10.76 ms |
SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.login_utilisateur AS login_utilisateur_4, a0_.date_parution_elite AS date_parution_elite_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12, a0_.mode_annonce AS mode_annonce_13, a0_.id_raison_cession AS id_raison_cession_14, a0_.date_creation_societe AS date_creation_societe_15, a0_.type_cession AS type_cession_16, a0_.description_activite AS description_activite_17, a0_.possession_brevets AS possession_brevets_18, a0_.possession_marques AS possession_marques_19, a0_.travail_export AS travail_export_20, a0_.raison_cession AS raison_cession_21, a0_.annee_n AS annee_n_22, a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23, a0_.ca_nmoinsun AS ca_nmoinsun_24, a0_.ca_nplusun AS ca_nplusun_25, a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26, a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27, a0_.marge_brute_n AS marge_brute_n_28, a0_.marge_brute_nplusun AS marge_brute_nplusun_29, a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30, a0_.EBE_nmoinsun AS EBE_nmoinsun_31, a0_.EBE_n AS EBE_n_32, a0_.EBE_nplusun AS EBE_nplusun_33, a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34, a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35, a0_.resultat_exploitation_n AS resultat_exploitation_n_36, a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37, a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38, a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39, a0_.resultat_net_n AS resultat_net_n_40, a0_.resultat_net_nplusun AS resultat_net_nplusun_41, a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42, a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43, a0_.nb_personnes_n AS nb_personnes_n_44, a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45, a0_.fonds_propres AS fonds_propres_46, a0_.dettes_financieres AS dettes_financieres_47, a0_.tresorerie_nette AS tresorerie_nette_48, a0_.points_forts AS points_forts_49, a0_.points_faibles AS points_faibles_50, a0_.positionnement_marche AS positionnement_marche_51, a0_.concurrence AS concurrence_52, a0_.prix_cession AS prix_cession_53, a0_.redressement_judiciaire AS redressement_judiciaire_54, a0_.apport_fp_min AS apport_fp_min_55, a0_.recherche_active AS recherche_active_56, a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57, a0_.elements_complementaires AS elements_complementaires_58, a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59, a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60, a0_.nom_contact AS nom_contact_61, a0_.email AS email_62, a0_.telephone AS telephone_63, a0_.commentaires AS commentaires_64, a0_.endettement_net_n AS endettement_net_n_65, a0_.id_langue AS id_langue_66, a0_.indicatif_telephone AS indicatif_telephone_67, a0_.date_fin_publique_elite AS date_fin_publique_elite_68 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_vendeur = 30893
Parameters:
[] |
| 3 | 10.75 ms |
SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.login_utilisateur AS login_utilisateur_4, a0_.date_parution_elite AS date_parution_elite_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12, a0_.mode_annonce AS mode_annonce_13, a0_.id_raison_cession AS id_raison_cession_14, a0_.date_creation_societe AS date_creation_societe_15, a0_.type_cession AS type_cession_16, a0_.description_activite AS description_activite_17, a0_.possession_brevets AS possession_brevets_18, a0_.possession_marques AS possession_marques_19, a0_.travail_export AS travail_export_20, a0_.raison_cession AS raison_cession_21, a0_.annee_n AS annee_n_22, a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23, a0_.ca_nmoinsun AS ca_nmoinsun_24, a0_.ca_nplusun AS ca_nplusun_25, a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26, a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27, a0_.marge_brute_n AS marge_brute_n_28, a0_.marge_brute_nplusun AS marge_brute_nplusun_29, a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30, a0_.EBE_nmoinsun AS EBE_nmoinsun_31, a0_.EBE_n AS EBE_n_32, a0_.EBE_nplusun AS EBE_nplusun_33, a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34, a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35, a0_.resultat_exploitation_n AS resultat_exploitation_n_36, a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37, a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38, a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39, a0_.resultat_net_n AS resultat_net_n_40, a0_.resultat_net_nplusun AS resultat_net_nplusun_41, a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42, a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43, a0_.nb_personnes_n AS nb_personnes_n_44, a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45, a0_.fonds_propres AS fonds_propres_46, a0_.dettes_financieres AS dettes_financieres_47, a0_.tresorerie_nette AS tresorerie_nette_48, a0_.points_forts AS points_forts_49, a0_.points_faibles AS points_faibles_50, a0_.positionnement_marche AS positionnement_marche_51, a0_.concurrence AS concurrence_52, a0_.prix_cession AS prix_cession_53, a0_.redressement_judiciaire AS redressement_judiciaire_54, a0_.apport_fp_min AS apport_fp_min_55, a0_.recherche_active AS recherche_active_56, a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57, a0_.elements_complementaires AS elements_complementaires_58, a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59, a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60, a0_.nom_contact AS nom_contact_61, a0_.email AS email_62, a0_.telephone AS telephone_63, a0_.commentaires AS commentaires_64, a0_.endettement_net_n AS endettement_net_n_65, a0_.id_langue AS id_langue_66, a0_.indicatif_telephone AS indicatif_telephone_67, a0_.date_fin_publique_elite AS date_fin_publique_elite_68 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_vendeur = 30893
Parameters:
[] |
| 4 | 10.17 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:
[
40319
]
|
| 5 | 10.22 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:
[
40319
]
|
| 6 | 10.83 ms |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 30893 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260319
Parameters:
[] |
| 7 | 10.65 ms |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 30893 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise'
Parameters:
[] |
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\AnnoncesVendeur | No errors. |
| App\Entity\SecteursActivite | No errors. |
| App\Entity\Commandes | No errors. |
| App\Entity\DetailsCommande | No errors. |
| App\Entity\Translation | No errors. |