Query Metrics
41
Database Queries
10
Different statements
21.09 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.78 ms (36.90%) |
27 |
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
]
|
4.04 ms (19.16%) |
1 |
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 ] |
3.41 ms (16.19%) |
1 |
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 ] |
1.65 ms (7.84%) |
4 |
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
]
|
0.96 ms (4.54%) |
2 |
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
]
|
0.82 ms (3.89%) |
1 |
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 ] |
0.69 ms (3.30%) |
1 |
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" ] |
0.66 ms (3.11%) |
2 |
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
]
|
0.58 ms (2.74%) |
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_magento = ? LIMIT 2
Parameters:
[
"Genny"
]
|
0.49 ms (2.35%) |
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.vat = ? LIMIT 2
Parameters:
[
"00531950202"
]
|
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. |