Query Metrics
31
Database Queries
5
Different statements
14.13 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.39 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.name AS name_5, t0.department AS department_6, t0.position AS position_7, t0.work_center AS work_center_8, t0.phone AS phone_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.accept_terms AS accept_terms_12, t0.accepted_at AS accepted_at_13, t0.active AS active_14, t0.is_verified AS is_verified_15, t0.surname AS surname_16, t0.ref AS ref_17, t0.type AS type_18, t0.photo AS photo_19, t0.company_id AS company_id_20, t0.supplier_id AS supplier_id_21, t0.notifications_config_id AS notifications_config_id_22, t0.company_client_id AS company_client_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
195
]
|
2 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.nif AS nif_4, t0.phone AS phone_5, t0.email AS email_6, t0.address AS address_7, t0.updated_at AS updated_at_8, t0.ref AS ref_9, t0.type AS type_10, t0.certifications AS certifications_11, t0.services AS services_12, t0.web_page AS web_page_13, t0.logo AS logo_14, t0.description AS description_15, t0.currency AS currency_16, t0.thema AS thema_17, t0.color AS color_18, t0.corporate_color AS corporate_color_19, t0.corporate_theme AS corporate_theme_20, t0.license_company_id AS license_company_id_21 FROM company t0 WHERE t0.id = ?
Parameters:
[
26
]
|
3 | 2.93 ms |
SELECT n0_.id AS id_0, n0_.group_ AS group__1, n0_.created_at AS created_at_2, n0_.message AS message_3, n0_.id_foreign AS id_foreign_4, n0_.name AS name_5, n0_.reference AS reference_6, n0_.path_name AS path_name_7, n0_.path_parameters AS path_parameters_8, n0_.message_aux AS message_aux_9, n0_.user_id AS user_id_10, n0_.company_id AS company_id_11 FROM notifications n0_ WHERE n0_.company_id = ? AND n0_.group_ IN (3, 4) ORDER BY n0_.id DESC LIMIT 1000
Parameters:
[
26
]
|
4 | 1.98 ms |
SELECT t0.id AS id_1, t0.units AS units_2, t0.observations AS observations_3, t0.state AS state_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.completed_at AS completed_at_7, t0.type AS type_8, t0.ref AS ref_9, t0.code AS code_10, t0.observations_supplier AS observations_supplier_11, t0.files_supplier AS files_supplier_12, t0.reject_date AS reject_date_13, t0.budget AS budget_14, t0.payment_terms AS payment_terms_15, t0.budget_valid_until AS budget_valid_until_16, t0.delivery_in AS delivery_in_17, t0.files_budget AS files_budget_18, t0.approve_user_date AS approve_user_date_19, t0.approve_chief_date AS approve_chief_date_20, t0.send_date AS send_date_21, t0.complete_date AS complete_date_22, t0.accept_ref AS accept_ref_23, t0.approve_supplier_date AS approve_supplier_date_24, t0.chief_confirm AS chief_confirm_25, t0.payment_terms_id AS payment_terms_id_26, t0.budget_date AS budget_date_27, t0.approve_date AS approve_date_28, t0.budget_required AS budget_required_29, t0.units_decrypted AS units_decrypted_30, t0.units_decrypted_date AS units_decrypted_date_31, t0.prototype_name AS prototype_name_32, t0.files_order AS files_order_33, t0.company_id AS company_id_34, t0.supplier_id AS supplier_id_35, t0.user_id AS user_id_36, t0.part_id AS part_id_37, t0.reject_user_id AS reject_user_id_38, t0.approve_user_user_id AS approve_user_user_id_39, t0.approve_chief_user_id AS approve_chief_user_id_40, t0.send_user_id AS send_user_id_41, t0.complete_user_id AS complete_user_id_42, t0.approve_supplier_user_id AS approve_supplier_user_id_43, t0.shipping_address_id AS shipping_address_id_44 FROM `order` t0 WHERE t0.supplier_id = ?
Parameters:
[
41
]
|
5 | 0.39 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1895
]
|
6 | 0.28 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1894
]
|
7 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1865
]
|
8 | 0.27 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1864
]
|
9 | 0.27 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1863
]
|
10 | 0.28 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1862
]
|
11 | 0.27 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1861
]
|
12 | 0.25 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1858
]
|
13 | 0.25 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1857
]
|
14 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1856
]
|
15 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1854
]
|
16 | 0.28 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1853
]
|
17 | 0.25 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1851
]
|
18 | 0.28 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1850
]
|
19 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1848
]
|
20 | 0.25 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1847
]
|
21 | 0.25 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1845
]
|
22 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1844
]
|
23 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1843
]
|
24 | 0.27 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1842
]
|
25 | 0.27 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1841
]
|
26 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1837
]
|
27 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1836
]
|
28 | 0.26 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1835
]
|
29 | 0.25 ms |
SELECT t0.id AS id_1, t0.seen_at AS seen_at_2, t0.notifications_id AS notifications_id_3, t0.user_id AS user_id_4 FROM notifications_seen t0 WHERE t0.notifications_id = ?
Parameters:
[
1834
]
|
30 | 0.36 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.name AS name_5, t0.department AS department_6, t0.position AS position_7, t0.work_center AS work_center_8, t0.phone AS phone_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.accept_terms AS accept_terms_12, t0.accepted_at AS accepted_at_13, t0.active AS active_14, t0.is_verified AS is_verified_15, t0.surname AS surname_16, t0.ref AS ref_17, t0.type AS type_18, t0.photo AS photo_19, t0.company_id AS company_id_20, t0.supplier_id AS supplier_id_21, t0.notifications_config_id AS notifications_config_id_22, t0.company_client_id AS company_client_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
66
]
|
31 | 0.32 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.name AS name_5, t0.department AS department_6, t0.position AS position_7, t0.work_center AS work_center_8, t0.phone AS phone_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.accept_terms AS accept_terms_12, t0.accepted_at AS accepted_at_13, t0.active AS active_14, t0.is_verified AS is_verified_15, t0.surname AS surname_16, t0.ref AS ref_17, t0.type AS type_18, t0.photo AS photo_19, t0.company_id AS company_id_20, t0.supplier_id AS supplier_id_21, t0.notifications_config_id AS notifications_config_id_22, t0.company_client_id AS company_client_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
176
]
|
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 |
|
App\Entity\Company |
|
App\Entity\Supplier |
|
App\Entity\NotificationsConfig | No errors. |
App\Entity\CompanyClient | No errors. |
App\Entity\OrderMessage | No errors. |
App\Entity\Equipment | No errors. |
App\Entity\LicenseCompany | No errors. |
App\Entity\Library | No errors. |
App\Entity\Part |
|
App\Entity\CompanySupplier | No errors. |
App\Entity\Material | No errors. |
App\Entity\CompanyAddress | No errors. |
App\Entity\Notifications | No errors. |
App\Entity\NotificationsSeen | No errors. |
App\Entity\Order | No errors. |
App\Entity\OrderMachineData | No errors. |