Query Metrics
41
Database Queries
10
Different statements
21.09 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.62 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:
[
2
]
|
2 | 0.69 ms |
SELECT c0_.id_magento AS id_magento_0, c0_.business_name AS business_name_1, c0_.vat AS vat_2, c0_.commercial_reference AS commercial_reference_3, c0_.commercial_emails AS commercial_emails_4, c0_.active AS active_5, c0_.deactivated_at AS deactivated_at_6, c0_.id AS id_7, c0_.created AS created_8, c0_.updated AS updated_9 FROM customer c0_ INNER JOIN customer_user c2_ ON c0_.id = c2_.customer_id INNER JOIN `user` u1_ ON u1_.id = c2_.user_id AND (u1_.id = ?) WHERE c0_.id IN (?) ORDER BY c0_.business_name ASC
Parameters:
[ 2 "5" ] |
3 | 0.58 ms |
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_magento = ? LIMIT 2
Parameters:
[
"Genny"
]
|
4 | 0.49 ms |
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.vat = ? LIMIT 2
Parameters:
[
"00531950202"
]
|
5 | 4.04 ms |
SELECT DISTINCT l0_.id AS id_0, l0_.date AS date_1 FROM log l0_ WHERE (l0_.customer_id = (?) AND l0_.registered = ?) AND (l0_.deleted_at IS NULL) ORDER BY l0_.date DESC LIMIT 200
Parameters:
[ 5 0 ] |
6 | 0.82 ms |
SELECT l0_.date AS date_0, l0_.billed_hours AS billed_hours_1, l0_.worked_hours AS worked_hours_2, l0_.registered AS registered_3, l0_.task_type AS task_type_4, l0_.status AS status_5, l0_.description AS description_6, l0_.id AS id_7, l0_.deleted_at AS deleted_at_8, l0_.created AS created_9, l0_.updated AS updated_10, l0_.user_id AS user_id_11, l0_.trello_card_id AS trello_card_id_12, l0_.customer_id AS customer_id_13, l0_.hourly_package_id AS hourly_package_id_14 FROM log l0_ WHERE (l0_.customer_id = (?) AND l0_.registered = ? AND l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.date DESC
Parameters:
[ 5 0 24802 24828 24827 24971 24689 24690 24691 24684 24685 24714 24679 24680 24708 24794 24711 24710 24709 24674 24673 24672 24712 24618 24793 24970 24966 24713 ] |
7 | 3.41 ms |
SELECT count(l0_.id) AS sclr_0 FROM log l0_ WHERE (l0_.customer_id = (?) AND l0_.registered = ?) AND (l0_.deleted_at IS NULL)
Parameters:
[ 5 0 ] |
8 | 0.42 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.hours AS hours_3, t0.invoice AS invoice_4, t0.notes AS notes_5, t0.open AS open_6, t0.hourly_sell_cost AS hourly_sell_cost_7, t0.reem_hours AS reem_hours_8, t0.id AS id_9, t0.deleted_at AS deleted_at_10, t0.created AS created_11, t0.updated AS updated_12, t0.customer_id AS customer_id_13 FROM hourly_package t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
446
]
|
9 | 0.37 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21623
]
|
10 | 0.40 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:
[
23
]
|
11 | 0.59 ms |
SELECT t0.date AS date_1, t0.billed_hours AS billed_hours_2, t0.worked_hours AS worked_hours_3, t0.registered AS registered_4, t0.task_type AS task_type_5, t0.status AS status_6, t0.description AS description_7, t0.id AS id_8, t0.deleted_at AS deleted_at_9, t0.created AS created_10, t0.updated AS updated_11, t0.user_id AS user_id_12, t0.trello_card_id AS trello_card_id_13, t0.customer_id AS customer_id_14, t0.hourly_package_id AS hourly_package_id_15 FROM log t0 WHERE t0.hourly_package_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
446
]
|
12 | 0.36 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21665
]
|
13 | 0.34 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21433
]
|
14 | 0.34 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
12442
]
|
15 | 0.32 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21760
]
|
16 | 0.34 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21727
]
|
17 | 0.39 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
19805
]
|
18 | 0.32 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21660
]
|
19 | 0.33 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21710
]
|
20 | 0.32 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21726
]
|
21 | 0.32 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21734
]
|
22 | 0.38 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21661
]
|
23 | 0.37 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21695
]
|
24 | 0.39 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
]
|
25 | 0.24 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.hours AS hours_3, t0.invoice AS invoice_4, t0.notes AS notes_5, t0.open AS open_6, t0.hourly_sell_cost AS hourly_sell_cost_7, t0.reem_hours AS reem_hours_8, t0.id AS id_9, t0.deleted_at AS deleted_at_10, t0.created AS created_11, t0.updated AS updated_12, t0.customer_id AS customer_id_13 FROM hourly_package t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
440
]
|
26 | 0.22 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
14207
]
|
27 | 0.23 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:
[
6
]
|
28 | 0.37 ms |
SELECT t0.date AS date_1, t0.billed_hours AS billed_hours_2, t0.worked_hours AS worked_hours_3, t0.registered AS registered_4, t0.task_type AS task_type_5, t0.status AS status_6, t0.description AS description_7, t0.id AS id_8, t0.deleted_at AS deleted_at_9, t0.created AS created_10, t0.updated AS updated_11, t0.user_id AS user_id_12, t0.trello_card_id AS trello_card_id_13, t0.customer_id AS customer_id_14, t0.hourly_package_id AS hourly_package_id_15 FROM log t0 WHERE t0.hourly_package_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
440
]
|
29 | 0.23 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
15966
]
|
30 | 0.23 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
12197
]
|
31 | 0.21 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
12441
]
|
32 | 0.21 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21601
]
|
33 | 0.23 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21634
]
|
34 | 0.22 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21676
]
|
35 | 0.24 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21678
]
|
36 | 0.23 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21654
]
|
37 | 0.22 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21617
]
|
38 | 0.24 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21658
]
|
39 | 0.24 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21644
]
|
40 | 0.34 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21655
]
|
41 | 0.23 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21650
]
|
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. |
App\Entity\PackageFile | No errors. |