Query Metrics

10 Database Queries
4 Different statements
1.34 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.24 ms
SELECT DISTINCT u0_.id AS id_0 FROM user u0_ LIMIT 20
Parameters:
[]
2 0.14 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3 FROM user u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  2
  11
  15
  5
  13
  12
  14
]
3 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.document_identity AS document_identity_4, t0.mobile_phone AS mobile_phone_5, t0.post_code AS post_code_6, t0.is_email_validated AS is_email_validated_7, t0.is_phone_validated AS is_phone_validated_8, t0.show_mobile_number AS show_mobile_number_9, t0.city_codigo_ibge AS city_codigo_ibge_10, t0.user_id AS user_id_11 FROM customer t0 WHERE t0.user_id = ?
Parameters:
[
  2
]
4 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.document_identity AS document_identity_4, t0.mobile_phone AS mobile_phone_5, t0.post_code AS post_code_6, t0.is_email_validated AS is_email_validated_7, t0.is_phone_validated AS is_phone_validated_8, t0.show_mobile_number AS show_mobile_number_9, t0.city_codigo_ibge AS city_codigo_ibge_10, t0.user_id AS user_id_11 FROM customer t0 WHERE t0.user_id = ?
Parameters:
[
  5
]
5 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.document_identity AS document_identity_4, t0.mobile_phone AS mobile_phone_5, t0.post_code AS post_code_6, t0.is_email_validated AS is_email_validated_7, t0.is_phone_validated AS is_phone_validated_8, t0.show_mobile_number AS show_mobile_number_9, t0.city_codigo_ibge AS city_codigo_ibge_10, t0.user_id AS user_id_11 FROM customer t0 WHERE t0.user_id = ?
Parameters:
[
  11
]
6 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.document_identity AS document_identity_4, t0.mobile_phone AS mobile_phone_5, t0.post_code AS post_code_6, t0.is_email_validated AS is_email_validated_7, t0.is_phone_validated AS is_phone_validated_8, t0.show_mobile_number AS show_mobile_number_9, t0.city_codigo_ibge AS city_codigo_ibge_10, t0.user_id AS user_id_11 FROM customer t0 WHERE t0.user_id = ?
Parameters:
[
  12
]
7 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.document_identity AS document_identity_4, t0.mobile_phone AS mobile_phone_5, t0.post_code AS post_code_6, t0.is_email_validated AS is_email_validated_7, t0.is_phone_validated AS is_phone_validated_8, t0.show_mobile_number AS show_mobile_number_9, t0.city_codigo_ibge AS city_codigo_ibge_10, t0.user_id AS user_id_11 FROM customer t0 WHERE t0.user_id = ?
Parameters:
[
  13
]
8 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.document_identity AS document_identity_4, t0.mobile_phone AS mobile_phone_5, t0.post_code AS post_code_6, t0.is_email_validated AS is_email_validated_7, t0.is_phone_validated AS is_phone_validated_8, t0.show_mobile_number AS show_mobile_number_9, t0.city_codigo_ibge AS city_codigo_ibge_10, t0.user_id AS user_id_11 FROM customer t0 WHERE t0.user_id = ?
Parameters:
[
  14
]
9 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.document_identity AS document_identity_4, t0.mobile_phone AS mobile_phone_5, t0.post_code AS post_code_6, t0.is_email_validated AS is_email_validated_7, t0.is_phone_validated AS is_phone_validated_8, t0.show_mobile_number AS show_mobile_number_9, t0.city_codigo_ibge AS city_codigo_ibge_10, t0.user_id AS user_id_11 FROM customer t0 WHERE t0.user_id = ?
Parameters:
[
  15
]
10 0.09 ms
SELECT count(*) AS sclr_0 FROM user u0_
Parameters:
[]

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\Customer No errors.
App\Entity\City No errors.