Query Metrics

7 Database Queries
4 Different statements
1.95 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.27 ms
SELECT DISTINCT c0_.id AS id_0 FROM city c0_ LIMIT 20 OFFSET 1280
Parameters:
[]
2 0.31 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.is_village AS is_village_4, c0_.title AS title_5, c0_.community_id AS community_id_6 FROM city c0_ WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1264
  1265
  1266
  1267
  1268
  1269
  1270
  1271
  1272
  1273
  1274
  1275
  1276
  1277
  1278
  1279
  1280
  1281
  1299
  1388
]
3 0.26 ms
SELECT count(c0_.id) AS sclr_0 FROM city c0_
Parameters:
[]
4 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.county_id AS county_id_6 FROM community t0 WHERE t0.id = ?
Parameters:
[
  80
]
5 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.county_id AS county_id_6 FROM community t0 WHERE t0.id = ?
Parameters:
[
  81
]
6 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.county_id AS county_id_6 FROM community t0 WHERE t0.id = ?
Parameters:
[
  82
]
7 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.county_id AS county_id_6 FROM community t0 WHERE t0.id = ?
Parameters:
[
  83
]

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\City No errors.
App\Entity\Community No errors.
App\Entity\Lead No errors.
App\Entity\Address No errors.
App\Entity\Street No errors.
App\Entity\County No errors.