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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.20 ms
SELECT DISTINCT i0_.id AS id_0, i0_.email AS email_1 FROM info_client i0_ ORDER BY i0_.email ASC LIMIT 20 OFFSET 20
Parameters:
[]
2 0.93 ms
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:
[
  209
  224
  247
  175
  228
  229
  223
  213
  212
  214
  215
  230
  198
  243
  241
  220
  221
  222
  236
  237
]
3 0.54 ms
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.