https://backend-dev.addvance3d.com/notificaciones?s=menu Return to referer URL

Query Metrics

30 Database Queries
4 Different statements
15.22 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 1.02 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:
[
  216
]
2 3.32 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 0.61 ms
SELECT t0.id AS id_1, t0.group_ AS group__2, t0.created_at AS created_at_3, t0.message AS message_4, t0.id_foreign AS id_foreign_5, t0.name AS name_6, t0.reference AS reference_7, t0.path_name AS path_name_8, t0.path_parameters AS path_parameters_9, t0.message_aux AS message_aux_10, t0.user_id AS user_id_11, t0.company_id AS company_id_12 FROM notifications t0 WHERE t0.company_id = ? ORDER BY t0.id DESC LIMIT 25
Parameters:
[
  26
]
4 2.88 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:
[
  1535
]
5 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:
[
  1534
]
6 0.21 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:
[
  1533
]
7 0.18 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:
[
  1532
]
8 0.18 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:
[
  1531
]
9 0.19 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:
[
  1530
]
10 0.18 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:
[
  1529
]
11 0.18 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:
[
  1528
]
12 0.18 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:
[
  1527
]
13 0.18 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:
[
  1526
]
14 0.17 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:
[
  1525
]
15 0.17 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:
[
  1524
]
16 0.19 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:
[
  1523
]
17 0.18 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:
[
  1522
]
18 0.19 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:
[
  1521
]
19 0.18 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:
[
  1520
]
20 0.18 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:
[
  1519
]
21 0.18 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:
[
  1518
]
22 0.18 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:
[
  1517
]
23 0.18 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:
[
  1516
]
24 0.18 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:
[
  1515
]
25 0.18 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:
[
  1514
]
26 0.19 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:
[
  1513
]
27 0.20 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:
[
  1512
]
28 0.18 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:
[
  1511
]
29 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
]
30 2.58 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
]

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
  • The field App\Entity\User#supplier is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Supplier#user does not contain the required 'mappedBy="supplier"' attribute.
  • If association App\Entity\User#supplier is many-to-one, then the inversed side App\Entity\Supplier#user has to be one-to-many.
App\Entity\Company
  • The association App\Entity\Company#parts refers to the owning side field App\Entity\Part#Company which does not exist.
App\Entity\Supplier
  • The mappings App\Entity\Supplier#users and App\Entity\User#supplier are inconsistent with each other.
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
  • The mappings App\Entity\Part#company and App\Entity\Company#parts are inconsistent with each other.
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.