Query Metrics

10 Database Queries
5 Different statements
1.99 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.28 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.status AS status_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.46 ms
SELECT DISTINCT l0_.id AS id_0 FROM license l0_ LIMIT 50
Parameters:
[]
3 0.26 ms
SELECT l0_.id AS id_0, l0_.qrcode AS qrcode_1, l0_.validity_duration AS validity_duration_2, l0_.validity_start AS validity_start_3, l0_.validity_end AS validity_end_4, l0_.status AS status_5, l0_.max_install_number AS max_install_number_6, l0_.version AS version_7, l0_.active AS active_8, l0_.distributor_id AS distributor_id_9, l0_.product_id AS product_id_10, l0_.health_center_id AS health_center_id_11, l0_.user_id AS user_id_12 FROM license l0_ WHERE l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3
  4
  5
  9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  6
  7
  8
]
4 0.14 ms
SELECT COUNT(l0_.id) AS sclr_0 FROM license l0_
Parameters:
[]
5 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.commercial_identifier AS commercial_identifier_3, t0.status AS status_4, t0.brand_id AS brand_id_5 FROM product t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.commercial_identifier AS commercial_identifier_3, t0.status AS status_4, t0.brand_id AS brand_id_5 FROM product t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.commercial_identifier AS commercial_identifier_3, t0.status AS status_4, t0.brand_id AS brand_id_5 FROM product t0 WHERE t0.id = ?
Parameters:
[
  3
]
8 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.commercial_identifier AS commercial_identifier_3, t0.status AS status_4, t0.brand_id AS brand_id_5 FROM product t0 WHERE t0.id = ?
Parameters:
[
  4
]
9 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.commercial_identifier AS commercial_identifier_3, t0.status AS status_4, t0.brand_id AS brand_id_5 FROM product t0 WHERE t0.id = ?
Parameters:
[
  6
]
10 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.commercial_identifier AS commercial_identifier_3, t0.status AS status_4, t0.brand_id AS brand_id_5 FROM product t0 WHERE t0.id = ?
Parameters:
[
  5
]

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\License No errors.
App\Entity\Distributor No errors.
App\Entity\Product No errors.
App\Entity\HealthCenter No errors.
App\Entity\LicenseLog No errors.
App\Entity\LicenseDevice No errors.
App\Entity\Brand No errors.
App\Entity\Feature No errors.
App\Entity\Exam No errors.
App\Entity\ExamData No errors.