Query Metrics

4 Database Queries
4 Different statements
4.85 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.active AS active_6, t0.deactivated_at AS deactivated_at_7, t0.hourly_resource_cost AS hourly_resource_cost_8, t0.id AS id_9, t0.uuid AS uuid_10, t0.created AS created_11, t0.updated AS updated_12, t0.hourly_package_id AS hourly_package_id_13 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 2.53 ms
SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM trello_card t0_ INNER JOIN trello_board t1_ ON t0_.board_id = t1_.id AND (t1_.deleted_at IS NULL) INNER JOIN customer c2_ ON t1_.customer_id = c2_.id WHERE (t1_.closed = 0 AND c2_.id = ?) AND (t0_.deleted_at IS NULL) ORDER BY t0_.name ASC LIMIT 20
Parameters:
[
  "2"
]
3 0.63 ms
SELECT t0_.id_trello AS id_trello_0, t0_.name AS name_1, t0_.id AS id_2, t0_.deleted_at AS deleted_at_3, t0_.created AS created_4, t0_.updated AS updated_5, t0_.board_id AS board_id_6 FROM trello_card t0_ INNER JOIN trello_board t1_ ON t0_.board_id = t1_.id AND (t1_.deleted_at IS NULL) INNER JOIN customer c2_ ON t1_.customer_id = c2_.id WHERE (t1_.closed = 0 AND c2_.id = ? AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (t0_.deleted_at IS NULL) ORDER BY t0_.name ASC
Parameters:
[
  "2"
  1112
  15051
  1224
  13597
  19944
  17990
  22073
  1098
  16793
  1190
  1228
  13543
  1100
  22282
  1132
  1223
  1133
  1221
  1218
  1214
]
4 1.24 ms
SELECT count(DISTINCT t0_.id) AS sclr_0 FROM trello_card t0_ INNER JOIN trello_board t1_ ON t0_.board_id = t1_.id AND (t1_.deleted_at IS NULL) INNER JOIN customer c2_ ON t1_.customer_id = c2_.id WHERE (t1_.closed = 0 AND c2_.id = ?) AND (t0_.deleted_at IS NULL)
Parameters:
[
  "2"
]

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\User No errors.
App\Entity\HourlyPackage No errors.
App\Entity\Log No errors.
App\Entity\Customer No errors.
App\Entity\TrelloCard No errors.
App\Entity\TrelloBoard No errors.