Query Metrics
9
Database Queries
9
Different statements
12.25 ms
Query time
17
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.20 ms |
SELECT t0.id AS id_1, t0.nom_groupe AS nom_groupe_2, t0.groupe_system AS groupe_system_3, t0.parent_groupe AS parent_groupe_4, t0.code_type_operateur AS code_type_operateur_5, t0.code_operateur AS code_operateur_6, t0.craeted_at AS craeted_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.en_relation_avec_id AS en_relation_avec_id_11 FROM metier.groupe t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.96 ms |
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.created_at AS created_at_2, t0_.created_by AS created_by_3, t0_.updated_by AS updated_by_4, t0_.updated_at AS updated_at_5 FROM metier.type_transformation t0_
Parameters:
[] |
| 3 | 1.68 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_ ORDER BY c0_.nom_cantonnement ASC
Parameters:
[] |
| 4 | 1.90 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_ ORDER BY e0_.raison_sociale_exploitant ASC
Parameters:
[] |
| 5 | 1.73 ms |
SELECT t0.id AS id_1, t0.numero_usine AS numero_usine_2, t0.raison_sociale_usine AS raison_sociale_usine_3, t0.personne_ressource AS personne_ressource_4, t0.cc_usine AS cc_usine_5, t0.tel_usine AS tel_usine_6, t0.fax_usine AS fax_usine_7, t0.adresse_usine AS adresse_usine_8, t0.localisation_usine AS localisation_usine_9, t0.ville AS ville_10, t0.capacite_usine AS capacite_usine_11, t0.sigle AS sigle_12, t0.email_personne_ressource AS email_personne_ressource_13, t0.mobile_personne_ressource AS mobile_personne_ressource_14, t0.export AS export_15, t0.code_exportateur AS code_exportateur_16, t0.created_at AS created_at_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.updated_at AS updated_at_20, t0.agree AS agree_21, t0.latitude AS latitude_22, t0.longitude AS longitude_23, t0.code_cantonnement_id AS code_cantonnement_id_24, t0.code_exploitant_id AS code_exploitant_id_25 FROM metier.usine t0
Parameters:
[] |
| 6 | 0.90 ms |
SELECT m0_.id AS id_0, m0_.nom_menu AS nom_menu_1, m0_.icon_menu AS icon_menu_2, m0_.parent_menu AS parent_menu_3, m0_.classname_menu AS classname_menu_4 FROM metier.menu m0_ WHERE m0_.parent_menu IS NULL ORDER BY m0_.nom_menu ASC
Parameters:
[] |
| 7 | 1.03 ms |
SELECT t0.id AS id_1, t0.sujet AS sujet_2, t0.description AS description_3, t0.from_user AS from_user_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.lu AS lu_7, t0.reference AS reference_8, t0.related_to_entity AS related_to_entity_9, t0.related_to_id AS related_to_id_10, t0.cloture AS cloture_11, t0.to_user_id AS to_user_id_12 FROM metier.notification t0 WHERE t0.to_user_id IS NULL LIMIT 5
Parameters:
[] |
| 8 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom_menu AS nom_menu_2, t0.icon_menu AS icon_menu_3, t0.parent_menu AS parent_menu_4, t0.classname_menu AS classname_menu_5 FROM metier.menu t0
Parameters:
[] |
| 9 | 1.65 ms |
SELECT t0.id AS id_1, t0.nom_menu AS nom_menu_2, t0.icon_menu AS icon_menu_3, t0.parent_menu AS parent_menu_4, t0.classname_menu AS classname_menu_5, t0.code_groupe_id AS code_groupe_id_6, t0.id_permission AS id_permission_7 FROM metier.menu_permission t0 WHERE t0.code_groupe_id = ?
Parameters:
[
1
]
|
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\Usine | No errors. |
| App\Entity\User |
|
| App\Entity\Groupe | No errors. |
| App\Entity\References\TypeOperateur | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\Administration\Gadget | No errors. |
| App\Entity\Observateur\Ticket | No errors. |
| App\Entity\References\TypeTransformation | No errors. |
| App\Entity\References\Cantonnement | No errors. |
| App\Entity\References\Dr | No errors. |
| App\Entity\References\Ddef | No errors. |
| App\Entity\References\Exploitant | No errors. |
| App\Entity\DocStats\Saisie\Lignepagedmv | No errors. |
| App\Entity\Transformation\Billon | No errors. |
| App\Entity\Transformation\FicheJourTransfo | No errors. |
| App\Entity\Transformation\Contrat | No errors. |
| App\Entity\Transformation\Pdt2Transfo | No errors. |
| App\Entity\Transformation\Elements | No errors. |
| App\Entity\References\PosteForestier | No errors. |
| App\Entity\References\Foret |
|
| App\Entity\References\Exportateur | No errors. |
| App\Entity\DocStats\Pages\Pagebrh | No errors. |
| App\Entity\DocStats\Pages\Pagebcbp | No errors. |
| App\Entity\DocStats\Pages\Pagepdtdrv | No errors. |
| App\Entity\DocStats\Pages\Pagebcburb | No errors. |
| App\Entity\References\Commercant | No errors. |
| App\Entity\Observateur\PublicationRapport | No errors. |
| App\Entity\References\QualiteExploitant | No errors. |
| App\Entity\Autorisation\Attribution | 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\DocStats\Entetes\Documentlje | No errors. |
| App\Entity\DocStats\Entetes\Documentbtgu | No errors. |
| App\Entity\DocStats\Pages\Pagebtgu | No errors. |
| App\Entity\Administration\DemandeOperateur | No errors. |
| App\Entity\DocStats\Entetes\Documentfp | No errors. |
| App\Entity\DocStats\Entetes\Documentetate |
|
| 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\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\Menu | No errors. |
| App\Entity\Administration\Notification | No errors. |
| App\Entity\MenuPermission | No errors. |
| App\Entity\References\ServiceMinef | No errors. |
| App\Entity\References\Direction | No errors. |
| App\Entity\Administration\Messagerie |
|
| App\Entity\References\Titre | No errors. |
| App\Entity\References\DocumentOperateur | No errors. |
| App\Entity\Admin\LogSnvlt | No errors. |
| App\Entity\References\Oi | No errors. |
| App\Entity\References\Caroi | No errors. |
| App\Entity\References\GrilleLegalite | No errors. |
| App\Entity\References\TypeAutorisation | No errors. |
| App\Entity\References\TypeDocumentStatistique |
|
| App\Entity\Helper\Media | No errors. |
| App\Entity\Observateur\Fichiers | No errors. |
| App\Entity\Observateur\TicketFiles | No errors. |
| App\Entity\References\Essence | No errors. |
| App\Entity\DocStats\Pages\Pagedmv | No errors. |
| App\Entity\Transformation\DetailFicheJourTransfo | No errors. |
| App\Entity\References\Pays | No errors. |
| App\Entity\Admin\Exercice |
|
| App\Entity\Transformation\Colis | No errors. |
| App\Entity\Transformation\TypeContrat | No errors. |
| App\Entity\Admin\Coupon | No errors. |
| App\Entity\Transformation\ElementsColis | No errors. |
| App\Entity\References\TypeForet | No errors. |
| App\Entity\Administration\InventaireForestier | No errors. |
| App\Entity\DocStats\Pages\Pageetatb | No errors. |
| App\Entity\Autorisation\AttributionPv | No errors. |
| App\Entity\Autorisation\ContratBcbgfh |
|
| App\Entity\References\Ugf | No errors. |
| App\Entity\DocStats\Entetes\Documentetatb |
|
| App\Entity\Autorisation\AgreementExportateur | No errors. |
| App\Entity\DocStats\Entetes\Documentbrh | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebrh | No errors. |
| App\Entity\References\PageDocGen | No errors. |
| App\Entity\DocStats\Entetes\Documentbcbp | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebcbp | No errors. |
| App\Entity\Administration\DocStatsGen | No errors. |
| App\Entity\DocStats\Entetes\Documentbcburb | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebcburb | No errors. |
| App\Entity\References\Nationalite | No errors. |
| App\Entity\DocStats\Entetes\Documentrsdpf | No errors. |
| App\Entity\Autorisation\AgreementCommercant | No errors. |
| App\Entity\Observateur\AnnexeRapport | No errors. |
| App\Entity\Observateur\AnalyseRapport | No errors. |
| App\Entity\Autorisation\Reprise | No errors. |
| App\Entity\DocStats\Pages\Pageetate2 | No errors. |
| App\Entity\Administration\ProspectionTemp | No errors. |
| App\Entity\References\ZoneHemispherique | No errors. |
| App\Entity\DocStats\Pages\Pagelje | No errors. |
| App\Entity\DocStats\Saisie\HistoriqueLje | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebtgu | No errors. |
| App\Entity\References\CircuitCommunication | No errors. |
| App\Entity\DocStats\Entetes\Documentcp | No errors. |
| App\Entity\DocStats\Entetes\Documentbrepf | No errors. |
| App\Entity\DocStats\Entetes\Documentbth | No errors. |
| App\Entity\Autorisation\AutorisationPs | No errors. |
| App\Entity\DocStats\Pages\Pagefp | No errors. |
| App\Entity\DocStats\Pages\Pageetate | No errors. |
| App\Entity\DocStats\Pages\Pageetatg | No errors. |
| App\Entity\DocStats\Pages\Pageetath | No errors. |
| App\Entity\DocStats\Pages\Pagedmp | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebrepf | No errors. |
| App\Entity\References\ProduitsUsine | No errors. |
| App\Entity\DocStats\Pages\Pagersdpf | No errors. |
| App\Entity\Transformation\Details2Transfo | No errors. |
| App\Entity\Transformation\EltsProd | No errors. |
| App\Entity\References\DetailsModele | No errors. |
| App\Entity\Administration\PieceJointe | No errors. |
| App\Entity\Administration\StockDoc | No errors. |
| App\Entity\DocStats\Entetes\SuiviDoc | No errors. |
| App\Entity\DocStats\Saisie\Lignepagecp | No errors. |
| App\Entity\DocStats\Saisie\Lignepagefp | No errors. |
| App\Entity\DocStats\Saisie\Lignepageetatg | No errors. |
| App\Entity\DocStats\Saisie\Lignepageetath | No errors. |
| App\Entity\DocStats\Saisie\Lignepagedmp | No errors. |
| App\Entity\Autorisation\AutorisationPdtdrv | No errors. |
| App\Entity\Autorisation\AutorisationExportateur | No errors. |
| App\Entity\Admin\DocumentsCoupon |
|
| App\Entity\Administration\FicheProspectionFc |
|
| App\Entity\DocStats\Entetes\Documentbcbgfh |
|
| App\Entity\References\Dcg | No errors. |
| App\Entity\DocStats\Pages\Pagecp | No errors. |
| App\Entity\DocStats\Saisie\Lignepagepdtdrv | No errors. |
| App\Entity\DocStats\Pages\Pagebth | No errors. |
| App\Entity\References\AttributairePs | No errors. |
| App\Entity\Autorisation\DepotCommercant | No errors. |
| App\Entity\Observateur\RecommendationAnalyse | No errors. |
| App\Entity\References\ModeleCommunication | No errors. |
| App\Entity\Autorisation\AgreementPs | No errors. |
| App\Entity\References\NaturePs | No errors. |
| App\Entity\Admin\Option | No errors. |
| App\Entity\Administration\ApkVer | No errors. |
| App\Entity\Autorisation\AgreementPdtdrv | No errors. |
| App\Entity\Autres\Contacter | No errors. |
| App\Entity\Blog\Abonne | No errors. |
| App\Entity\Blog\ArticleBlog | No errors. |
| App\Entity\Blog\AutresRubriques | No errors. |
| App\Entity\Blog\Categorie | No errors. |
| App\Entity\Blog\CategoryPublication | No errors. |
| App\Entity\Blog\Comment | No errors. |
| App\Entity\Blog\FichierPublication | No errors. |
| App\Entity\Blog\GroupePublication | No errors. |
| App\Entity\Blog\Media | No errors. |
| App\Entity\Blog\MenuBlog |
|
| App\Entity\Blog\Page | No errors. |
| App\Entity\Blog\Publication | No errors. |
| App\Entity\DemandeAutorisation\DemandeDocument | No errors. |
| App\Entity\DemandeAutorisation\Document | No errors. |
| App\Entity\DemandeAutorisation\EtapeValidation | No errors. |
| App\Entity\DemandeAutorisation\NouvelleDemande | No errors. |
| App\Entity\DemandeAutorisation\TypeDemande |
|
| App\Entity\DemandeAutorisation\TypeDemandeDetail | No errors. |
| App\Entity\DemandeAutorisation\TypeDocument | No errors. |
| App\Entity\DemandeAutorisation\ValidationAction | No errors. |
| App\Entity\DetailsCircuitActes |
|
| App\Entity\Diffusion | No errors. |
| App\Entity\DisponibiliteParcBilles | No errors. |
| App\Entity\DisponibiliteParcBillons | No errors. |
| App\Entity\DocStats\DocsStats | No errors. |
| App\Entity\DocStats\DonneesSodefor | No errors. |
| App\Entity\DocStats\ImportData |
|
| App\Entity\DocStats\Pages\Pagebcbgfh |
|
| App\Entity\DocStats\Saisie\Lignepagebcbgfh |
|
| App\Entity\Document | No errors. |
| App\Entity\Employe | No errors. |
| App\Entity\Observateur\StatutAlerte | No errors. |
| App\Entity\Observateur\StatutRapportOI | No errors. |
| App\Entity\Observateur\TypeRapport | No errors. |
| App\Entity\Observateur\TypeRapportOi | No errors. |
| App\Entity\Paiement\CatalogueServices | No errors. |
| App\Entity\Paiement\Transaction | No errors. |
| App\Entity\Paiement\TypePaiement | No errors. |
| App\Entity\Pef | No errors. |
| App\Entity\References\Imprimeur | No errors. |
| App\Entity\References\Preference | No errors. |
| App\Entity\References\SousPrefecture | No errors. |
| App\Entity\References\TypeDemande | No errors. |
| App\Entity\References\TypeDiffusion | No errors. |
| App\Entity\References\TypeDossierPs | No errors. |
| App\Entity\References\TypeModeleCommunication | No errors. |
| App\Entity\References\TypesDemandeur | No errors. |
| App\Entity\References\TypesService | No errors. |
| App\Entity\Requetes\CubageEssences | No errors. |
| App\Entity\Requetes\MenuRequetes | No errors. |
| App\Entity\Requetes\PerformanceBrh | No errors. |
| App\Entity\Requetes\PerformanceBrhJour | No errors. |
| App\Entity\Requetes\Qt | No errors. |
| App\Entity\Requetes\QuotaTransferable | No errors. |
| App\Entity\Requetes\StatsByExploitantAnneeEssence | No errors. |
| App\Entity\Requetes\StatsByForetAnneeEssence | No errors. |
| App\Entity\Requetes\StatsMensuelles | No errors. |
| App\Entity\Requetes\TypeRequetes | No errors. |
| App\Entity\ResetPasswordRequest | No errors. |
| App\Entity\Vues\ChargementCours | No errors. |
| App\Entity\Vues\EssenceVolumeTop10 | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |