https://newdev.documanager.es/list

Query Metrics

30 Database Queries
3 Different statements
6.76 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.max_disk_quota AS max_disk_quota_3, t0.max_threads AS max_threads_4, t5.id AS id_6, t5.db_name AS db_name_7, t5.db_user AS db_user_8, t5.db_password AS db_password_9, t5.db_url AS db_url_10, t5.db_port AS db_port_11, t5.empresa_id AS empresa_id_12 FROM empresa t0 LEFT JOIN conexion_bd t5 ON t5.empresa_id = t0.id
Parameters:
[]
3 0.51 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  40
]
4 0.14 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  40
]
5 0.58 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  45
]
6 0.17 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  45
]
7 0.28 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  57
]
8 0.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  57
]
9 0.21 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  75
]
10 0.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  75
]
11 0.22 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  79
]
12 0.10 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  79
]
13 0.21 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  84
]
14 0.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  84
]
15 0.25 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  94
]
16 0.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  94
]
17 0.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  101
]
18 0.13 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  101
]
19 0.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  106
]
20 0.15 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  106
]
21 0.23 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  107
]
22 0.12 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  107
]
23 0.21 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  110
]
24 0.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  110
]
25 0.20 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  111
]
26 0.18 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  111
]
27 0.25 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  112
]
28 0.12 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  112
]
29 0.22 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  114
]
30 0.09 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.is_admin AS is_admin_5, t0.connection AS connection_6, t0.empresa_id AS empresa_id_7 FROM users t0 WHERE t0.empresa_id = ?
Parameters:
[
  114
]

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\Usuario
  • The association App\Entity\Usuario#empresa refers to the inverse side field App\Entity\Empresa#usuarios which does not exist.
App\Entity\Empresa No errors.
App\Entity\ConexionBD No errors.