Query Metrics

41 Database Queries
10 Different statements
21.09 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.