Query Metrics
16
Database Queries
4
Different statements
165.47 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.72 ms |
SELECT t0.id_investisseur AS id_investisseur_1, t0.id_utilisateur AS id_utilisateur_2, t0.titre_investisseur AS titre_investisseur_3, t0.mode AS mode_4, t0.nom_contact AS nom_contact_5, t0.prenom_contact AS prenom_contact_6, t0.indicatif_telephone_contact AS indicatif_telephone_contact_7, t0.telephone_contact AS telephone_contact_8, t0.email_contact AS email_contact_9, t0.devise AS devise_10, t0.montant_investissement_min AS montant_investissement_min_11, t0.montant_investissement_min_devise AS montant_investissement_min_devise_12, t0.montant_investissement_max AS montant_investissement_max_13, t0.montant_investissement_max_devise AS montant_investissement_max_devise_14, t0.id_secteurs_activite AS id_secteurs_activite_15, t0.mots_cles_secteurs_activite AS mots_cles_secteurs_activite_16, t0.generaliste AS generaliste_17, t0.strategie_investissement AS strategie_investissement_18, t0.commentaires AS commentaires_19, t0.date_mise_a_jour AS date_mise_a_jour_20, t0.date_relance AS date_relance_21, t0.relance_mise_a_jour AS relance_mise_a_jour_22, t0.reference_perso AS reference_perso_23, t0.deja_publique AS deja_publique_24, t0.date_parution AS date_parution_25, t0.type_investisseur AS type_investisseur_26, t0.nom_structure AS nom_structure_27, t0.capital_detenu AS capital_detenu_28, t0.stade_investissement AS stade_investissement_29, t0.suivi AS suivi_30, t0.date_parution_initiale AS date_parution_initiale_31, t0.role_souhaite AS role_souhaite_32, t0.date_demande AS date_demande_33, t0.is_international AS is_international_34, t0.id_localisations_recherchees AS id_localisations_recherchees_35 FROM fusacq_dbo.investisseurs_prives t0 WHERE t0.id_investisseur = ? AND t0.mode = ? LIMIT 1
Parameters:
[ "505" "publique" ] |
| 2 | 11.79 ms |
SELECT i0_.id_investisseur AS id_investisseur_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE (i0_.mode = 'publique')
Parameters:
[] |
| 3 | 10.13 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, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite_fonds = ? LIMIT 1
Parameters:
[
"3"
]
|
| 4 | 10.21 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "tarif_MER_investi" "oui" "fr" "FUSACQ" ] |
| 5 | 10.26 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "nb_relation_mer_offre_1" "oui" "fr" "FUSACQ" ] |
| 6 | 10.26 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "tarif_pack_mer_5_fusacq" "oui" "fr" "FUSACQ" ] |
| 7 | 10.28 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "nb_relation_mer_offre_2" "oui" "fr" "FUSACQ" ] |
| 8 | 10.28 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "tarif_pack_mer_10_fusacq" "oui" "fr" "FUSACQ" ] |
| 9 | 10.28 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "nb_relation_mer_offre_3" "oui" "fr" "FUSACQ" ] |
| 10 | 10.19 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "tarif_pack_mer_20_fusacq" "oui" "fr" "FUSACQ" ] |
| 11 | 10.20 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "nb_relation_mer_offre_abo_annuel_1" "oui" "fr" "FUSACQ" ] |
| 12 | 10.20 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "tarif_abo_10_MER_mois_fusacq" "oui" "fr" "FUSACQ" ] |
| 13 | 10.22 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "nb_relation_mer_offre_abo_annuel_2" "oui" "fr" "FUSACQ" ] |
| 14 | 10.18 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "tarif_abo_20_MER_mois_fusacq" "oui" "fr" "FUSACQ" ] |
| 15 | 10.16 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "nb_relation_mer_offre_abo_annuel_3" "oui" "fr" "FUSACQ" ] |
| 16 | 10.14 ms |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
Parameters:
[ "tarif_abo_30_MER_mois_fusacq" "oui" "fr" "FUSACQ" ] |
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\InvestisseursPrives | No errors. |
| App\Entity\SecteursActivite | No errors. |
| App\Entity\Translation | No errors. |
| App\Entity\DataParametreSite | No errors. |
| App\Entity\ParametreSite | No errors. |