GET http://scpc-crm.comptoir-hammami.com/commercial/visiteRev/chantier/826

Response
200 OK
Browse referrer URL
IP
102.172.209.63
Profiled on
Token
1e5ab1

Query Metrics

6 Database Queries
6 Different statements
30.33 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
23.57 ms
(77.70%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.observation AS observation_4, t0.numrev AS numrev_5, t0.typercl AS typercl_6, t0.latitudes AS latitudes_7, t0.longitudes AS longitudes_8, t0.produit_id AS produit_id_9, t0.produit_id AS produit_id_10, t0.revendeur_item_id AS revendeur_item_id_11, t0.zone_id AS zone_id_12 FROM revendeur t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.35 ms
(7.75%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.metrage AS metrage_3, t0.raidechausse AS raidechausse_4, t0.plan_daction AS plan_daction_5, t0.nombre_visite AS nombre_visite_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.revendeur AS revendeur_9, t0.architect AS architect_10, t0.pi AS pi_11, t0.demande AS demande_12, t0.date_modification AS date_modification_13, t0.egc AS egc_14, t0.valeur AS valeur_15, t0.budgetrev AS budgetrev_16, t0.typerev AS typerev_17, t0.products AS products_18, t0.concurrent AS concurrent_19, t0.mcarre AS mcarre_20, t0.vglobal AS vglobal_21, t0.financement AS financement_22, t0.datedebut AS datedebut_23, t0.otherclient AS otherclient_24, t0.choix AS choix_25, t0.type_id AS type_id_26, t0.commercial_id AS commercial_id_27, t0.nature_id AS nature_id_28, t0.zone_id AS zone_id_29, t0.direction_id AS direction_id_30, t0.client_id AS client_id_31, t0.departement_id AS departement_id_32 FROM chantier t0 WHERE t0.id = ?
Parameters: 
[
  "826"
]
View formatted query    View runnable query    Explain query
1.30 ms
(4.30%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  160
]
View formatted query    View runnable query    Explain query
1.14 ms
(3.76%) 		1 
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.quantite AS quantite_3, t0.category_id AS category_id_4, t0.type_chantier_id AS type_chantier_id_5 FROM produit t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.11 ms
(3.67%) 		1 
SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.user_id AS user_id_3 FROM commercial t0 WHERE t0.user_id = ? LIMIT 1
Parameters: 
[
  160
]
View formatted query    View runnable query    Explain query
0.86 ms
(2.83%) 		1 
SELECT t0.id AS id_1, t0.type AS type_2 FROM type_chantier t0
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\Chantier No errors.
App\Entity\TypeChantier No errors.
App\Entity\Commercial No errors.
App\Entity\NatureChantier No errors.
App\Entity\Zone No errors.
App\Entity\Directeur No errors.
App\Entity\Revendeur
  • The mappings App\Entity\Revendeur#revendeurItems and App\Entity\RevendeurItem#revendeurItem are inconsistent with each other.
App\Entity\Departement No errors.
App\Entity\Visite No errors.
App\Entity\Intervenant No errors.
App\Entity\Tache No errors.
App\Entity\ProductMetrage
  • The mappings App\Entity\ProductMetrage#typeProduit and App\Entity\TypeProduit#productMetrages are inconsistent with each other.
App\Entity\ChantierProduit No errors.
App\Entity\ChantierProduct No errors.
App\Entity\User No errors.
App\Entity\Event No errors.
App\Entity\Concurrentielle No errors.
App\Entity\Branche No errors.
App\Entity\Constat No errors.
App\Entity\Calendar No errors.
App\Entity\Produit
  • The association App\Entity\Produit#chantiers refers to the owning side field App\Entity\Chantier#product which does not exist.
App\Entity\Category No errors.
App\Entity\RevendeurProduit
  • The mappings App\Entity\RevendeurProduit#produit and App\Entity\produit#revendeurProduits are inconsistent with each other.
App\Entity\ConcurrentielleProduit No errors.
App\Entity\RevendeurProduct No errors.
App\Entity\RevendeurItem
  • The field App\Entity\RevendeurItem#revendeurItem is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\revendeur#revendeurItem does not contain the required 'mappedBy="revendeurItem"' attribute.
  • If association App\Entity\RevendeurItem#revendeurItem is many-to-one, then the inversed side App\Entity\Revendeur#revendeurItem has to be one-to-many.