https://flexenergie.org/entreprise/details/876

Query Metrics

11 Database Queries
10 Different statements
22.88 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.38 ms
(19.14%)
1
SELECT t0.id AS id_1, t0.duree AS duree_2, t0.valeur AS valeur_3, t0.pdl AS pdl_4, t0.car AS car_5, t0.prix_moyen AS prix_moyen_6, t0.fournisseur AS fournisseur_7, t0.date_debut AS date_debut_8, t0.date_fin AS date_fin_9, t0.date_signature AS date_signature_10, t0.collaborateur_id AS collaborateur_id_11, t0.entreprise_id AS entreprise_id_12 FROM contrat t0 WHERE t0.entreprise_id = ?
Parameters:
[
  876
]
3.87 ms
(16.90%)
1
SELECT t0.id AS id_1, t0.entreprise_id AS entreprise_id_2, t0.titre AS titre_3, t0.description AS description_4, t0.echeance AS echeance_5, t0.completer AS completer_6, t0.utilisateur AS utilisateur_7, t0.niveau AS niveau_8 FROM rappel t0 WHERE t0.entreprise_id = ?
Parameters:
[
  876
]
2.89 ms
(12.64%)
1
SELECT t0.id AS id_1, t0.entreprise_id AS entreprise_id_2, t0.adresse_compteur AS adresse_compteur_3, t0.pdl AS pdl_4, t0.date_debut AS date_debut_5, t0.date_fin AS date_fin_6, t0.ps AS ps_7, t0.profil AS profil_8, t0.car AS car_9, t0.fournisseur AS fournisseur_10, t0.prix AS prix_11 FROM electric_meter t0 WHERE t0.entreprise_id = ?
Parameters:
[
  876
]
2.59 ms
(11.31%)
1
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.civilite AS civilite_4, t0.fonction AS fonction_5, t0.entreprise_id AS entreprise_id_6, t0.fixe AS fixe_7, t0.portable AS portable_8, t0.email AS email_9 FROM contact t0 WHERE t0.entreprise_id = ?
Parameters:
[
  876
]
2.09 ms
(9.13%)
1
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.naf AS naf_4, t0.adresse AS adresse_5, t0.code_insee AS code_insee_6, t0.statut AS statut_7, t0.utilisateur AS utilisateur_8, t0.rcs AS rcs_9, t0.num_voie AS num_voie_10, t0.code_postal AS code_postal_11, t0.commune AS commune_12 FROM entreprise t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  876
]
1.92 ms
(8.38%)
2
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.reset_token AS reset_token_6, t0.reset_token_expires_at AS reset_token_expires_at_7, t0.is_pro_access_requested AS is_pro_access_requested_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  56
]
1.60 ms
(6.97%)
1
SELECT t0.id AS id_1, t0.entreprise_id AS entreprise_id_2, t0.adresse_compteur AS adresse_compteur_3, t0.pdl AS pdl_4, t0.date_debut AS date_debut_5, t0.date_fin AS date_fin_6, t0.profil AS profil_7, t0.car AS car_8, t0.fournisseur AS fournisseur_9, t0.prix AS prix_10 FROM gas_meter t0 WHERE t0.entreprise_id = ?
Parameters:
[
  876
]
1.43 ms
(6.23%)
1
SELECT t0.id AS id_1, t0.entreprise_id AS entreprise_id_2, t0.texte AS texte_3, t0.date_creation AS date_creation_4, t0.user_id AS user_id_5 FROM note t0 WHERE t0.entreprise_id = ? ORDER BY t0.date_creation DESC
Parameters:
[
  876
]
1.10 ms
(4.81%)
1
SELECT t0.id AS id_1, t0.entreprise_id AS entreprise_id_2, t0.fournisseur AS fournisseur_3, t0.login AS login_4, t0.mdp AS mdp_5, t0.lien AS lien_6 FROM espace_client t0 WHERE t0.entreprise_id = ?
Parameters:
[
  876
]
1.03 ms
(4.49%)
1
SELECT t0.id AS id_1, t0.entreprise_id AS entreprise_id_2, t0.notes AS notes_3, t0.date AS date_4, t0.valeur AS valeur_5 FROM cspe t0 WHERE t0.entreprise_id = ?
Parameters:
[
  876
]

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\User No errors.
App\Entity\Entreprise No errors.
App\Entity\PricingGrid No errors.
App\Entity\Contrat No errors.
App\Entity\Facture No errors.
App\Entity\Note No errors.
App\Entity\Rappel No errors.
App\Entity\ElectricMeter No errors.
App\Entity\GasMeter No errors.
App\Entity\CSPE No errors.
App\Entity\EspaceClient No errors.
App\Entity\Contact No errors.