Query Metrics
4
Database Queries
4
Different statements
4.85 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |