Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.01 ms Query time

2 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	2.01 ms	SELECT t0.id AS id_1, t0.numero_exploitant AS numero_exploitant_2, t0.raison_sociale_exploitant AS raison_sociale_exploitant_3, t0.qualite_exploitant AS qualite_exploitant_4, t0.marteau_exploitant AS marteau_exploitant_5, t0.adresse_exploitant AS adresse_exploitant_6, t0.tel_exploitant AS tel_exploitant_7, t0.ncc_exploitant AS ncc_exploitant_8, t0.sigle AS sigle_9, t0.datecreation AS datecreation_10, t0.forme_juridique AS forme_juridique_11, t0.capital AS capital_12, t0.rccim AS rccim_13, t0.situation_geographie AS situation_geographie_14, t0.mobile_exploitant AS mobile_exploitant_15, t0.email_info AS email_info_16, t0.fax AS fax_17, t0.nb_salarie AS nb_salarie_18, t0.ca AS ca_19, t0.gerant AS gerant_20, t0.personne_ressource AS personne_ressource_21, t0.email_personne_ressource AS email_personne_ressource_22, t0.mobile_personne_ressource AS mobile_personne_ressource_23, t0.export AS export_24, t0.code_exportateur AS code_exportateur_25, t0.created_at AS created_at_26, t0.created_by AS created_by_27, t0.updated_by AS updated_by_28, t0.updated_at AS updated_at_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.filiale_id AS filiale_id_33 FROM metier.exploitant t0 WHERE t0.id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.numero_exploitant AS numero_exploitant_2, t0.raison_sociale_exploitant AS raison_sociale_exploitant_3, t0.qualite_exploitant AS qualite_exploitant_4, t0.marteau_exploitant AS marteau_exploitant_5, t0.adresse_exploitant AS adresse_exploitant_6, t0.tel_exploitant AS tel_exploitant_7, t0.ncc_exploitant AS ncc_exploitant_8, t0.sigle AS sigle_9, t0.datecreation AS datecreation_10, t0.forme_juridique AS forme_juridique_11, t0.capital AS capital_12, t0.rccim AS rccim_13, t0.situation_geographie AS situation_geographie_14, t0.mobile_exploitant AS mobile_exploitant_15, t0.email_info AS email_info_16, t0.fax AS fax_17, t0.nb_salarie AS nb_salarie_18, t0.ca AS ca_19, t0.gerant AS gerant_20, t0.personne_ressource AS personne_ressource_21, t0.email_personne_ressource AS email_personne_ressource_22, t0.mobile_personne_ressource AS mobile_personne_ressource_23, t0.export AS export_24, t0.code_exportateur AS code_exportateur_25, t0.created_at AS created_at_26, t0.created_by AS created_by_27, t0.updated_by AS updated_by_28, t0.updated_at AS updated_at_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.filiale_id AS filiale_id_33 FROM metier.exploitant t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.numero_exploitant AS numero_exploitant_2, t0.raison_sociale_exploitant AS raison_sociale_exploitant_3, t0.qualite_exploitant AS qualite_exploitant_4, t0.marteau_exploitant AS marteau_exploitant_5, t0.adresse_exploitant AS adresse_exploitant_6, t0.tel_exploitant AS tel_exploitant_7, t0.ncc_exploitant AS ncc_exploitant_8, t0.sigle AS sigle_9, t0.datecreation AS datecreation_10, t0.forme_juridique AS forme_juridique_11, t0.capital AS capital_12, t0.rccim AS rccim_13, t0.situation_geographie AS situation_geographie_14, t0.mobile_exploitant AS mobile_exploitant_15, t0.email_info AS email_info_16, t0.fax AS fax_17, t0.nb_salarie AS nb_salarie_18, t0.ca AS ca_19, t0.gerant AS gerant_20, t0.personne_ressource AS personne_ressource_21, t0.email_personne_ressource AS email_personne_ressource_22, t0.mobile_personne_ressource AS mobile_personne_ressource_23, t0.export AS export_24, t0.code_exportateur AS code_exportateur_25, t0.created_at AS created_at_26, t0.created_by AS created_by_27, t0.updated_by AS updated_by_28, t0.updated_at AS updated_at_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.filiale_id AS filiale_id_33 FROM metier.exploitant t0 WHERE t0.id = 4;

#▲

Time

Info

2.01 ms

SELECT t0.id AS id_1, t0.numero_exploitant AS numero_exploitant_2, t0.raison_sociale_exploitant AS raison_sociale_exploitant_3, t0.qualite_exploitant AS qualite_exploitant_4, t0.marteau_exploitant AS marteau_exploitant_5, t0.adresse_exploitant AS adresse_exploitant_6, t0.tel_exploitant AS tel_exploitant_7, t0.ncc_exploitant AS ncc_exploitant_8, t0.sigle AS sigle_9, t0.datecreation AS datecreation_10, t0.forme_juridique AS forme_juridique_11, t0.capital AS capital_12, t0.rccim AS rccim_13, t0.situation_geographie AS situation_geographie_14, t0.mobile_exploitant AS mobile_exploitant_15, t0.email_info AS email_info_16, t0.fax AS fax_17, t0.nb_salarie AS nb_salarie_18, t0.ca AS ca_19, t0.gerant AS gerant_20, t0.personne_ressource AS personne_ressource_21, t0.email_personne_ressource AS email_personne_ressource_22, t0.mobile_personne_ressource AS mobile_personne_ressource_23, t0.export AS export_24, t0.code_exportateur AS code_exportateur_25, t0.created_at AS created_at_26, t0.created_by AS created_by_27, t0.updated_by AS updated_by_28, t0.updated_at AS updated_at_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.filiale_id AS filiale_id_33 FROM metier.exploitant t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.numero_exploitant AS numero_exploitant_2,
  t0.raison_sociale_exploitant AS raison_sociale_exploitant_3,
  t0.qualite_exploitant AS qualite_exploitant_4,
  t0.marteau_exploitant AS marteau_exploitant_5,
  t0.adresse_exploitant AS adresse_exploitant_6,
  t0.tel_exploitant AS tel_exploitant_7,
  t0.ncc_exploitant AS ncc_exploitant_8,
  t0.sigle AS sigle_9,
  t0.datecreation AS datecreation_10,
  t0.forme_juridique AS forme_juridique_11,
  t0.capital AS capital_12,
  t0.rccim AS rccim_13,
  t0.situation_geographie AS situation_geographie_14,
  t0.mobile_exploitant AS mobile_exploitant_15,
  t0.email_info AS email_info_16,
  t0.fax AS fax_17,
  t0.nb_salarie AS nb_salarie_18,
  t0.ca AS ca_19,
  t0.gerant AS gerant_20,
  t0.personne_ressource AS personne_ressource_21,
  t0.email_personne_ressource AS email_personne_ressource_22,
  t0.mobile_personne_ressource AS mobile_personne_ressource_23,
  t0.export AS export_24,
  t0.code_exportateur AS code_exportateur_25,
  t0.created_at AS created_at_26,
  t0.created_by AS created_by_27,
  t0.updated_by AS updated_by_28,
  t0.updated_at AS updated_at_29,
  t0.latitude AS latitude_30,
  t0.longitude AS longitude_31,
  t0.code_cantonnement_id AS code_cantonnement_id_32,
  t0.filiale_id AS filiale_id_33
FROM
  metier.exploitant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_exploitant AS numero_exploitant_2, t0.raison_sociale_exploitant AS raison_sociale_exploitant_3, t0.qualite_exploitant AS qualite_exploitant_4, t0.marteau_exploitant AS marteau_exploitant_5, t0.adresse_exploitant AS adresse_exploitant_6, t0.tel_exploitant AS tel_exploitant_7, t0.ncc_exploitant AS ncc_exploitant_8, t0.sigle AS sigle_9, t0.datecreation AS datecreation_10, t0.forme_juridique AS forme_juridique_11, t0.capital AS capital_12, t0.rccim AS rccim_13, t0.situation_geographie AS situation_geographie_14, t0.mobile_exploitant AS mobile_exploitant_15, t0.email_info AS email_info_16, t0.fax AS fax_17, t0.nb_salarie AS nb_salarie_18, t0.ca AS ca_19, t0.gerant AS gerant_20, t0.personne_ressource AS personne_ressource_21, t0.email_personne_ressource AS email_personne_ressource_22, t0.mobile_personne_ressource AS mobile_personne_ressource_23, t0.export AS export_24, t0.code_exportateur AS code_exportateur_25, t0.created_at AS created_at_26, t0.created_by AS created_by_27, t0.updated_by AS updated_by_28, t0.updated_at AS updated_at_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.filiale_id AS filiale_id_33 FROM metier.exploitant t0 WHERE t0.id = 4;

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\Exploitant	No errors.
App\Entity\References\Cantonnement	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\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\Admin\Exercice	The mappings App\Entity\Admin\Exercice#lignepagebcbps and App\Entity\DocStats\Saisie\Lignepagebcbp#exercice are inconsistent with each other.

Symfony Profiler

GET http://boislegal.ci/getInfosExploitations/4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping