Query Metrics

6 Database Queries
6 Different statements
6.45 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.83 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.phone_number AS phone_number_15, t16.id AS id_17, t16.birthdate AS birthdate_18, t16.hire_date AS hire_date_19, t16.birth_place AS birth_place_20, t16.gender AS gender_21, t16.is_conveyed AS is_conveyed_22, t16.hourly_rate AS hourly_rate_23, t16.is_approved AS is_approved_24, t16.rate_by_word AS rate_by_word_25, t16.rate_by_page AS rate_by_page_26, t16.is_self_employed AS is_self_employed_27, t16.siren_number AS siren_number_28, t16.is_filled AS is_filled_29, t16.is_sworn_in AS is_sworn_in_30, t16.comments AS comments_31, t16.languages AS languages_32, t16.user_id AS user_id_33, t16.address_id AS address_id_34, t35.id AS id_36, t35.is_approved AS is_approved_37, t35.is_filled AS is_filled_38, t35.address_id AS address_id_39, t35.user_id AS user_id_40, t41.id AS id_42, t41.name AS name_43, t41.is_approved AS is_approved_44, t41.is_filled AS is_filled_45, t41.siren AS siren_46, t41.customer_email AS customer_email_47, t41.referent_function AS referent_function_48, t41.accounting_email AS accounting_email_49, t41.accounting_phone AS accounting_phone_50, t41.client_type AS client_type_51, t41.address_id AS address_id_52, t41.user_id AS user_id_53 FROM users t0 LEFT JOIN interpreter t16 ON t16.user_id = t0.id LEFT JOIN individual_customer t35 ON t35.user_id = t0.id LEFT JOIN professional_customer t41 ON t41.user_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
2 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.is_filled AS is_filled_4, t0.siren AS siren_5, t0.customer_email AS customer_email_6, t0.referent_function AS referent_function_7, t0.accounting_email AS accounting_email_8, t0.accounting_phone AS accounting_phone_9, t0.client_type AS client_type_10, t0.address_id AS address_id_11, t0.user_id AS user_id_12 FROM professional_customer t0 WHERE t0.is_approved = ?
Parameters:
[
  0
]
3 0.32 ms
SELECT t0.id AS id_1, t0.is_approved AS is_approved_2, t0.is_filled AS is_filled_3, t0.address_id AS address_id_4, t0.user_id AS user_id_5 FROM individual_customer t0 WHERE t0.is_approved = ?
Parameters:
[
  0
]
4 0.61 ms
SELECT COUNT(*) FROM individual_customer t0 WHERE t0.is_approved = ?
Parameters:
[
  0
]
5 0.32 ms
SELECT COUNT(*) FROM professional_customer t0 WHERE t0.is_approved = ?
Parameters:
[
  0
]
6 0.80 ms
SELECT COUNT(*) FROM interpreter t0 WHERE t0.is_approved = ?
Parameters:
[
  0
]

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.