Query Metrics
5
Database Queries
5
Different statements
61.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
15.18 ms (24.54%) |
1 |
SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_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_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11, CASE WHEN (a0_.id_pays = ? AND (a0_.id_region = '' OR a0_.id_region IS NULL OR a0_.id_region = ?) AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? THEN 4 WHEN (a0_.id_pays = ? AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? THEN 3 WHEN a0_.id_pays = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? THEN 2 ELSE 1 END AS sclr_12 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL) AND (a0_.id_pays = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?) ORDER BY sclr_12 DESC, a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 1 OFFSET 240
Parameters:
[ 33 "33_99" 33 "33,%" "%,33,%" "%,33" 33 "33%" "%,33%" 33 "33%" "%,33%" 33 "33%" "%,33%" ] |
|
15.00 ms (24.25%) |
1 |
SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_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_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11, CASE WHEN (a0_.id_pays = ? AND (a0_.id_region = '' OR a0_.id_region IS NULL OR a0_.id_region = ?) AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? THEN 4 WHEN (a0_.id_pays = ? AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? THEN 3 WHEN a0_.id_pays = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? THEN 2 ELSE 1 END AS sclr_12 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL) AND (a0_.id_pays = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?) ORDER BY sclr_12 DESC, a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 1 OFFSET 242
Parameters:
[ 33 "33_99" 33 "33,%" "%,33,%" "%,33" 33 "33%" "%,33%" 33 "33%" "%,33%" 33 "33%" "%,33%" ] |
|
10.72 ms (17.32%) |
1 |
SELECT t0.id_utilisateur AS id_utilisateur_1, t0.login_utilisateur AS login_utilisateur_2, t0.password_encrypted_utilisateur AS password_encrypted_utilisateur_3, t0.is_verified AS is_verified_4, t0.mode_utilisateur AS mode_utilisateur_5, t0.type_abonnement AS type_abonnement_6, t0.date_demande_inscription AS date_demande_inscription_7, t0.date_demande_inscription_complete AS date_demande_inscription_complete_8, t0.date_relance AS date_relance_9, t0.date_inscription_reelle AS date_inscription_reelle_10, t0.langue_utilisee AS langue_utilisee_11, t0.type_utilisateur AS type_utilisateur_12, t0.nom_utilisateur AS nom_utilisateur_13, t0.prenom_utilisateur AS prenom_utilisateur_14, t0.email_utilisateur AS email_utilisateur_15, t0.societe_utilisateur AS societe_utilisateur_16, t0.rcs_utilisateur AS rcs_utilisateur_17, t0.relance_mail_utilisateur AS relance_mail_utilisateur_18, t0.pieces_necessaires AS pieces_necessaires_19, t0.pays_utilisateur AS pays_utilisateur_20, t0.region_utilisateur AS region_utilisateur_21, t0.ville_utilisateur AS ville_utilisateur_22, t0.code_postal_utilisateur AS code_postal_utilisateur_23, t0.adresse_utilisateur AS adresse_utilisateur_24, t0.commentaire_utilisateur AS commentaire_utilisateur_25, t0.litige_utilisateur AS litige_utilisateur_26, t0.compte_facturation AS compte_facturation_27, t0.factur_nom_societe AS factur_nom_societe_28, t0.factur_adresse AS factur_adresse_29, t0.factur_code_postal AS factur_code_postal_30, t0.factur_ville AS factur_ville_31, t0.factur_pays AS factur_pays_32, t0.factur_id_pays AS factur_id_pays_33, t0.id_type_structure AS id_type_structure_34, t0.telephone_utilisateur AS telephone_utilisateur_35, t0.indicatif_tel AS indicatif_tel_36, t0.id_structure AS id_structure_37, t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_38, t0.fonction_utilisateur AS fonction_utilisateur_39, t0.lien_internet AS lien_internet_40, t0.tva_intracommunautaire AS tva_intracommunautaire_41, t0.id_client_publicite AS id_client_publicite_42, t0.inscription_partenaire AS inscription_partenaire_43, t0.site_partenaire AS site_partenaire_44, t0.provenance_connexion_fusacq AS provenance_connexion_fusacq_45, t0.suivi AS suivi_46, t0.date_derniere_connexion AS date_derniere_connexion_47, t0.date_desinscription_fusacq AS date_desinscription_fusacq_48, t0.type_commande AS type_commande_49, t0.date_derniere_commande AS date_derniere_commande_50, t0.date_dernier_depot_annonce AS date_dernier_depot_annonce_51, t0.etat_relance AS etat_relance_52, t0.agence_utilisateur AS agence_utilisateur_53, t0.cookie_authentification AS cookie_authentification_54, t0.id_pays_utilisateur AS id_pays_utilisateur_55, t0.id_region AS id_region_56, t0.contact_suite_inscription AS contact_suite_inscription_57, t0.id_societe_prestataire AS id_societe_prestataire_58, t0.association_societe_prestataire AS association_societe_prestataire_59, t0.mail_note_qualite_mer AS mail_note_qualite_mer_60, t0.provenance_notoriete_fusacq AS provenance_notoriete_fusacq_61, t0.id_reseau_commerce AS id_reseau_commerce_62, t0.montant_contact_defaut AS montant_contact_defaut_63, t0.montant_contact_international_defaut AS montant_contact_international_defaut_64, t0.type_utilisateur_commerce AS type_utilisateur_commerce_65, t0.annee_naissance AS annee_naissance_66, t0.civilite AS civilite_67, t0.inscription_validee AS inscription_validee_68, t0.plateforme_inscription AS plateforme_inscription_69, t0.frequence_envoi_alertes_commerces AS frequence_envoi_alertes_commerces_70, t0.date_dernier_envoi_alerte_commerces AS date_dernier_envoi_alerte_commerces_71, t0.mode_reglement_commerce AS mode_reglement_commerce_72, t0.id_agence_commerce AS id_agence_commerce_73, t0.provenance_connexion_commerces AS provenance_connexion_commerces_74, t0.importer_annonces_pdc_sur_ce_compte AS importer_annonces_pdc_sur_ce_compte_75, t0.email_invalide AS email_invalide_76, t0.personne_societe AS personne_societe_77, t0.type_utilisateur_franchise AS type_utilisateur_franchise_78, t0.mode_reglement_franchise AS mode_reglement_franchise_79, t0.montant_cv_defaut AS montant_cv_defaut_80, t0.montant_cv_international_defaut AS montant_cv_international_defaut_81, t0.id_cv AS id_cv_82, t0.telephone_utilisateur_back AS telephone_utilisateur_back_83, t0.site_derniere_connexion AS site_derniere_connexion_84, t0.date_derniere_notification_propose_cv_pdc AS date_derniere_notification_propose_cv_pdc_85, t0.devise AS devise_86, t0.id_pays_tarif_applicable AS id_pays_tarif_applicable_87, t0.identifiant_entreprise AS identifiant_entreprise_88, t0.non_assujetti_tva AS non_assujetti_tva_89 FROM fusacq_dbo.utilisateurs t0 WHERE t0.login_utilisateur = ? LIMIT 1
Parameters:
[
"102118"
]
|
|
10.55 ms (17.06%) |
1 |
SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_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_.ca_max AS ca_max_4, a0_.id_pays AS id_pays_5, a0_.id_region AS id_region_6, a0_.id_departement AS id_departement_7, a0_.autres_localisations AS autres_localisations_8, a0_.type_acquereur AS type_acquereur_9, a0_.id_secteur_activite AS id_secteur_activite_10, a0_.login_utilisateur AS login_utilisateur_11, a0_.ca_min AS ca_min_12, a0_.ca_max AS ca_max_13, a0_.ca_societe AS ca_societe_14, a0_.res_net_societe AS res_net_societe_15, a0_.type_raprochement AS type_raprochement_16, a0_.mode_annonce AS mode_annonce_17, a0_.description_activite AS description_activite_18, a0_.raison_achat AS raison_achat_19, a0_.nb_personnes_max AS nb_personnes_max_20, a0_.nb_personnes_min AS nb_personnes_min_21, a0_.date_creation_societe AS date_creation_societe_22, a0_.nb_personnes_societe AS nb_personnes_societe_23, a0_.ca_societe AS ca_societe_24, a0_.res_net_societe AS res_net_societe_25, a0_.description_activite_societe AS description_activite_societe_26, a0_.date_creation_societe AS date_creation_societe_27, a0_.annee_naissance_repreneur AS annee_naissance_repreneur_28, a0_.apport_perso_repreneur AS apport_perso_repreneur_29, a0_.formation_repreneur AS formation_repreneur_30, a0_.parcours_pro_repreneur AS parcours_pro_repreneur_31, a0_.elements_complementaires AS elements_complementaires_32, a0_.recherche_active AS recherche_active_33, a0_.demarche AS demarche_34, a0_.recherche_entreprise_difficulte AS recherche_entreprise_difficulte_35, a0_.nom_contact AS nom_contact_36, a0_.email AS email_37, a0_.telephone AS telephone_38, a0_.commentaires AS commentaires_39, a0_.id_langue AS id_langue_40, a0_.indicatif_telephone AS indicatif_telephone_41 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_acheteur = 16021
Parameters:
[] |
|
10.41 ms (16.83%) |
1 |
SELECT v0_.id_valorisation AS id_valorisation_0, v1_.titre_valorisation AS titre_valorisation_1, v1_.ca_n_affichage AS ca_n_affichage_2, v1_.date_mois_operation AS date_mois_operation_3, v1_.societe_difficulte AS societe_difficulte_4, v1_.type_rachat AS type_rachat_5, v1_.type_acquereur AS type_acquereur_6, v1_.description_publique AS description_publique_7 FROM fusacq_dbo.valorisations_liens_annonces_vendeur v0_ LEFT JOIN valorisations v1_ ON (v0_.id_valorisation = v1_.id_valorisation) WHERE v0_.id_annonce = ? AND v1_.mode = 'publique' ORDER BY v1_.date_mois_operation DESC LIMIT 10
Parameters:
[
16021
]
|
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\AnnoncesAcheteur | No errors. |
| App\Entity\Utilisateur | No errors. |
| App\Entity\SecteursActivite | No errors. |
| App\Entity\Valorisations | No errors. |
| App\Entity\ValorisationsLiensAnnoncesVendeur | No errors. |
| App\Entity\Translation | No errors. |