GET http://15.235.65.28/Members/RegisterNew

Query Metrics

9 Database Queries
9 Different statements
10.53 ms Query time
4 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.85 ms
SELECT t0.id AS id_1, t0.libelle_operateur AS libelle_operateur_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.updated_at AS updated_at_6 FROM metier.type_operateur t0 ORDER BY t0.libelle_operateur ASC
Parameters:
[]
2 1.42 ms
SELECT e0_.id AS id_0, e0_.numero_exploitant AS numero_exploitant_1, e0_.raison_sociale_exploitant AS raison_sociale_exploitant_2, e0_.qualite_exploitant AS qualite_exploitant_3, e0_.marteau_exploitant AS marteau_exploitant_4, e0_.adresse_exploitant AS adresse_exploitant_5, e0_.tel_exploitant AS tel_exploitant_6, e0_.ncc_exploitant AS ncc_exploitant_7, e0_.sigle AS sigle_8, e0_.datecreation AS datecreation_9, e0_.forme_juridique AS forme_juridique_10, e0_.capital AS capital_11, e0_.rccim AS rccim_12, e0_.situation_geographie AS situation_geographie_13, e0_.mobile_exploitant AS mobile_exploitant_14, e0_.email_info AS email_info_15, e0_.fax AS fax_16, e0_.nb_salarie AS nb_salarie_17, e0_.ca AS ca_18, e0_.gerant AS gerant_19, e0_.personne_ressource AS personne_ressource_20, e0_.email_personne_ressource AS email_personne_ressource_21, e0_.mobile_personne_ressource AS mobile_personne_ressource_22, e0_.export AS export_23, e0_.code_exportateur AS code_exportateur_24, e0_.created_at AS created_at_25, e0_.created_by AS created_by_26, e0_.updated_by AS updated_by_27, e0_.updated_at AS updated_at_28, e0_.latitude AS latitude_29, e0_.longitude AS longitude_30, e0_.code_cantonnement_id AS code_cantonnement_id_31, e0_.filiale_id AS filiale_id_32 FROM metier.exploitant e0_ WHERE e0_.email_personne_ressource IS NOT NULL ORDER BY e0_.raison_sociale_exploitant ASC
Parameters:
[]
3 1.64 ms
SELECT u0_.id AS id_0, u0_.numero_usine AS numero_usine_1, u0_.raison_sociale_usine AS raison_sociale_usine_2, u0_.personne_ressource AS personne_ressource_3, u0_.cc_usine AS cc_usine_4, u0_.tel_usine AS tel_usine_5, u0_.fax_usine AS fax_usine_6, u0_.adresse_usine AS adresse_usine_7, u0_.localisation_usine AS localisation_usine_8, u0_.ville AS ville_9, u0_.capacite_usine AS capacite_usine_10, u0_.sigle AS sigle_11, u0_.email_personne_ressource AS email_personne_ressource_12, u0_.mobile_personne_ressource AS mobile_personne_ressource_13, u0_.export AS export_14, u0_.code_exportateur AS code_exportateur_15, u0_.created_at AS created_at_16, u0_.created_by AS created_by_17, u0_.updated_by AS updated_by_18, u0_.updated_at AS updated_at_19, u0_.agree AS agree_20, u0_.latitude AS latitude_21, u0_.longitude AS longitude_22, u0_.code_cantonnement_id AS code_cantonnement_id_23, u0_.code_exploitant_id AS code_exploitant_id_24 FROM metier.usine u0_ WHERE u0_.email_personne_ressource IS NOT NULL ORDER BY u0_.raison_sociale_usine ASC
Parameters:
[]
4 1.22 ms
SELECT e0_.id AS id_0, e0_.code_exportateur AS code_exportateur_1, e0_.raison_sociale_exportateur AS raison_sociale_exportateur_2, e0_.adresse_exportateur AS adresse_exportateur_3, e0_.tel_exportateur AS tel_exportateur_4, e0_.email_exportateur AS email_exportateur_5, e0_.date_creation AS date_creation_6, e0_.personne_ressource AS personne_ressource_7, e0_.email_personne_ressource AS email_personne_ressource_8, e0_.mobile_personne_ressource AS mobile_personne_ressource_9, e0_.created_at AS created_at_10, e0_.created_by AS created_by_11, e0_.updated_at AS updated_at_12, e0_.updated_by AS updated_by_13, e0_.sigle AS sigle_14, e0_.statut AS statut_15, e0_.code_cantonnement_id AS code_cantonnement_id_16 FROM metier.exportateur e0_ WHERE e0_.email_personne_ressource IS NOT NULL ORDER BY e0_.raison_sociale_exportateur ASC
Parameters:
[]
5 0.84 ms
SELECT d0_.id AS id_0, d0_.denomination AS denomination_1, d0_.email_responsable AS email_responsable_2, d0_.created_at AS created_at_3, d0_.created_by AS created_by_4, d0_.updated_by AS updated_by_5, d0_.updated_at AS updated_at_6, d0_.personne_ressource AS personne_ressource_7, d0_.email_personne_ressource AS email_personne_ressource_8, d0_.mobile_personne_ressource AS mobile_personne_ressource_9 FROM metier.dr d0_ WHERE d0_.email_personne_ressource IS NOT NULL ORDER BY d0_.denomination ASC
Parameters:
[]
6 1.20 ms
SELECT c0_.id AS id_0, c0_.nom_cantonnement AS nom_cantonnement_1, c0_.email_responsable AS email_responsable_2, c0_.created_at AS created_at_3, c0_.created_by AS created_by_4, c0_.updated_by AS updated_by_5, c0_.updated_at AS updated_at_6, c0_.personne_ressource AS personne_ressource_7, c0_.email_personne_ressource AS email_personne_ressource_8, c0_.mobile_personne_ressource AS mobile_personne_ressource_9, c0_.code_dr_id AS code_dr_id_10, c0_.code_ddef_id AS code_ddef_id_11 FROM metier.cantonnement c0_ WHERE c0_.email_personne_ressource IS NOT NULL ORDER BY c0_.nom_cantonnement ASC
Parameters:
[]
7 1.03 ms
SELECT d0_.id AS id_0, d0_.nom_ddef AS nom_ddef_1, d0_.email_responsable AS email_responsable_2, d0_.created_at AS created_at_3, d0_.created_by AS created_by_4, d0_.updated_by AS updated_by_5, d0_.updated_at AS updated_at_6, d0_.personne_ressource AS personne_ressource_7, d0_.email_personne_ressource AS email_personne_ressource_8, d0_.mobile_personne_ressource AS mobile_personne_ressource_9, d0_.code_dr_id AS code_dr_id_10 FROM metier.ddef d0_ WHERE d0_.email_personne_ressource IS NOT NULL ORDER BY d0_.nom_ddef ASC
Parameters:
[]
8 0.78 ms
SELECT p0_.id AS id_0, p0_.denomination AS denomination_1, p0_.email_responsable AS email_responsable_2, p0_.situation_geographique AS situation_geographique_3, p0_.created_at AS created_at_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.updated_at AS updated_at_7, p0_.personne_ressource AS personne_ressource_8, p0_.email_personne_ressource AS email_personne_ressource_9, p0_.mobile_personne_ressource AS mobile_personne_ressource_10, p0_.code_cantonnement_id AS code_cantonnement_id_11 FROM metier.poste_forestier p0_ WHERE p0_.email_personne_ressource IS NOT NULL ORDER BY p0_.denomination ASC
Parameters:
[]
9 0.54 ms
SELECT d0_.id AS id_0, d0_.denomination AS denomination_1, d0_.sigle AS sigle_2, d0_.email_responsable AS email_responsable_3, d0_.created_at AS created_at_4, d0_.created_by AS created_by_5, d0_.updated_by AS updated_by_6, d0_.updated_at AS updated_at_7, d0_.personne_ressource AS personne_ressource_8, d0_.email_personne_ressource AS email_personne_ressource_9, d0_.mobile_personne_ressource AS mobile_personne_ressource_10 FROM metier.direction d0_ WHERE d0_.email_personne_ressource IS NOT NULL ORDER BY d0_.sigle ASC
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
alt doctrine.dbal.alt_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\References\TypeOperateur No errors.
App\Entity\User
  • The mappings App\Entity\User#code_cantonnement and App\Entity\References\Cantonnement#utilisateurs are inconsistent with each other.
  • The mappings App\Entity\User#mes_messages and App\Entity\Administration\Messagerie#code_utilisateur are inconsistent with each other.
App\Entity\References\GrilleLegalite No errors.
App\Entity\Administration\DemandeOperateur No errors.
App\Entity\References\DocumentOperateur No errors.
App\Entity\References\TypeAutorisation No errors.
App\Entity\References\TypeDocumentStatistique
  • The field App\Entity\References\TypeDocumentStatistique#documentetatbs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DocStats\Entetes\Documentetatb#type_document does not contain the required 'inversedBy="documentetatbs"' attribute.
App\Entity\Administration\Gadget No errors.
App\Entity\Helper\Media No errors.
App\Entity\Groupe No errors.
App\Entity\References\Exploitant No errors.
App\Entity\References\Cantonnement No errors.
App\Entity\References\QualiteExploitant No errors.
App\Entity\Autorisation\Attribution No errors.
App\Entity\References\Usine No errors.
App\Entity\DocStats\Saisie\Lignepageetate No errors.
App\Entity\DocStats\Saisie\Lignepageetate2 No errors.
App\Entity\Autorisation\AutorisationPv No errors.
App\Entity\Administration\FicheProspection No errors.
App\Entity\DocStats\Saisie\Lignepagelje No errors.
App\Entity\References\TypeTransformation No errors.
App\Entity\DocStats\Pages\Pagebrh No errors.
App\Entity\DocStats\Entetes\Documentlje No errors.
App\Entity\DocStats\Entetes\Documentbtgu No errors.
App\Entity\DocStats\Pages\Pagebtgu No errors.
App\Entity\DocStats\Entetes\Documentfp No errors.
App\Entity\DocStats\Pages\Pagebcbp No errors.
App\Entity\DocStats\Entetes\Documentetate
  • The field 'App\Entity\DocStats\Entetes\Documentetate#updated_at' has the property type 'DateTimeInterface' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\DocStats\Entetes\Documentetate2 No errors.
App\Entity\DocStats\Entetes\Documentetatg No errors.
App\Entity\DocStats\Entetes\Documentetath No errors.
App\Entity\DocStats\Entetes\Documentdmp No errors.
App\Entity\DocStats\Entetes\Documentdmv No errors.
App\Entity\Transformation\Contrat No errors.
App\Entity\DocStats\Pages\Pagebcburb No errors.
App\Entity\DocStats\Pages\Pagebrepf No errors.
App\Entity\DocStats\Saisie\Lignepagersdpf No errors.
App\Entity\DocStats\Entetes\Documentpdtdrv No errors.
App\Entity\Transformation\Fiche2Transfo No errors.
App\Entity\Transformation\FicheLot No errors.
App\Entity\Transformation\FicheLotProd No errors.
App\Entity\References\Exportateur No errors.
App\Entity\Autorisation\AgreementExportateur No errors.
App\Entity\References\Dr No errors.
App\Entity\References\Ddef No errors.
App\Entity\DocStats\Pages\Pagepdtdrv No errors.
App\Entity\References\Commercant No errors.
App\Entity\Observateur\PublicationRapport No errors.
App\Entity\Observateur\Ticket No errors.
App\Entity\References\PosteForestier No errors.
App\Entity\References\Foret
  • The association App\Entity\References\Foret#documentetatbs refers to the owning side field App\Entity\DocStats\Entetes\Documentetatb#code_exploitant which does not exist.
App\Entity\References\Direction No errors.
App\Entity\References\ServiceMinef No errors.
App\Entity\References\DetailsModele No errors.
App\Entity\References\CircuitCommunication No errors.