GET http://kondashop.com/ka/info-client?page=1&sort%5Bemail%5D=ASC

Query Metrics

3 Database Queries
3 Different statements
5.01 ms Query time
2 Invalid entities
20 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.63 ms
(72.40%)
1
SELECT DISTINCT i0_.id AS id_0, i0_.email AS email_1 FROM info_client i0_ ORDER BY i0_.email ASC LIMIT 20
Parameters:
[]
0.91 ms
(18.23%)
1
SELECT i0_.nom AS nom_0, i0_.tel AS tel_1, i0_.ville AS ville_2, i0_.email AS email_3, i0_.datelivraison AS datelivraison_4, i0_.commentaire AS commentaire_5, i0_.pointfidelite AS pointfidelite_6, i0_.id AS id_7, i0_.quantite AS quantite_8 FROM info_client i0_ WHERE i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.email ASC
Parameters:
[
  226
  244
  176
  178
  184
  219
  205
  206
  207
  245
  216
  217
  218
  227
  225
  201
  246
  210
  211
  209
]
0.47 ms
(9.37%)
1
SELECT count(i0_.id) AS sclr_0 FROM info_client i0_
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\InfoClient 20

Entities Mapping

Class Mapping errors
App\Entity\InfoClient
  • The association App\Entity\InfoClient#pointsTransactions refers to the owning side field App\Entity\PointsTransaction#infoclient which does not exist.
App\Entity\PointsTransaction
  • The mappings App\Entity\PointsTransaction#infoClient and App\Entity\InfoClient#pointsTransactions are inconsistent with each other.