Query Metrics
6
Database Queries
5
Different statements
5.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.07 ms (35.78%) |
2 |
SELECT t0.id_trello AS id_trello_1, t0.name AS name_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created AS created_5, t0.updated AS updated_6, t0.board_id AS board_id_7 FROM trello_card t0 WHERE t0.board_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
|
1.03 ms (17.75%) |
1 |
SELECT t0.id_trello AS id_trello_1, t0.link AS link_2, t0.name AS name_3, t0.closed AS closed_4, t0.id AS id_5, t0.deleted_at AS deleted_at_6, t0.created AS created_7, t0.updated AS updated_8, t0.customer_id AS customer_id_9 FROM trello_board t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 20
Parameters:
[
72
]
|
|
0.96 ms (16.62%) |
1 |
SELECT t0.id_trello AS id_trello_1, t0.link AS link_2, t0.name AS name_3, t0.closed AS closed_4, t0.id AS id_5, t0.deleted_at AS deleted_at_6, t0.created AS created_7, t0.updated AS updated_8, t0.customer_id AS customer_id_9 FROM trello_board t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
72
]
|
|
0.92 ms (15.78%) |
1 |
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:
[
42
]
|
|
0.82 ms (14.07%) |
1 |
SELECT t0.id_magento AS id_magento_1, t0.business_name AS business_name_2, t0.vat AS vat_3, t0.commercial_reference AS commercial_reference_4, t0.commercial_emails AS commercial_emails_5, t0.active AS active_6, t0.deactivated_at AS deactivated_at_7, t0.id AS id_8, t0.created AS created_9, t0.updated AS updated_10 FROM customer t0 WHERE t0.id = ?
Parameters:
[
72
]
|
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\TrelloBoard | No errors. |
| App\Entity\TrelloCard | No errors. |