Query Metrics

11 Database Queries
7 Different statements
7.67 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.07 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.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.date_of_birth AS date_of_birth_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.website AS website_17, t0.biography AS biography_18, t0.gender AS gender_19, t0.locale AS locale_20, t0.timezone AS timezone_21, t0.phone AS phone_22, t0.facebook_uid AS facebook_uid_23, t0.facebook_name AS facebook_name_24, t0.facebook_data AS facebook_data_25, t0.twitter_uid AS twitter_uid_26, t0.twitter_name AS twitter_name_27, t0.twitter_data AS twitter_data_28, t0.gplus_uid AS gplus_uid_29, t0.gplus_name AS gplus_name_30, t0.gplus_data AS gplus_data_31, t0.token AS token_32, t0.two_step_code AS two_step_code_33, t0.id AS id_34 FROM adm_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  3
]
2 0.71 ms
SELECT t0.name AS name_1, t0.roles AS roles_2, t0.id AS id_3 FROM fos_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = ?
Parameters:
[
  3
]
3 0.66 ms
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM reserve r0_ WHERE r0_.start_date = ?
Parameters:
[
  "2024-09-21 17:00:00"
]
4 0.57 ms
SELECT DISTINCT r0_.id AS id_0, r0_.id AS id_1 FROM reserve r0_ WHERE r0_.start_date = ? ORDER BY r0_.id DESC LIMIT 32
Parameters:
[
  "2024-09-21 17:00:00"
]
5 0.55 ms
SELECT r0_.id AS id_0, r0_.start_date AS start_date_1, r0_.end_date AS end_date_2, r0_.amount AS amount_3, r0_.status AS status_4, r0_.notes AS notes_5, r0_.motorcycle_id AS motorcycle_id_6, r0_.client_id AS client_id_7 FROM reserve r0_ WHERE r0_.start_date = ? AND r0_.id IN (?) ORDER BY r0_.id DESC
Parameters:
[
  "2024-09-21 17:00:00"
  [
    194
    193
    114
  ]
]
6 0.49 ms
SELECT t0.id AS id_1, t0.mark AS mark_2, t0.model AS model_3, t0.vin_number AS vin_number_4, t0.registration_number AS registration_number_5, t0.issue_year AS issue_year_6, t0.payment_amount AS payment_amount_7, t0.color AS color_8 FROM motorcycle t0 WHERE t0.id = ?
Parameters:
[
  4
]
7 0.44 ms
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.password AS password_3, t0.user_number AS user_number_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.middle_name AS middle_name_7, t0.date_of_birth AS date_of_birth_8, t0.passport_number AS passport_number_9, t0.passport_id AS passport_id_10, t0.passport_issue_date AS passport_issue_date_11, t0.passport_issuing_authority AS passport_issuing_authority_12, t0.registration_address AS registration_address_13, t0.drivers_license_number AS drivers_license_number_14, t0.drivers_license_date AS drivers_license_date_15, t0.date_signing_contract AS date_signing_contract_16, t0.notes AS notes_17 FROM client t0 WHERE t0.id = ?
Parameters:
[
  233
]
8 0.43 ms
SELECT t0.id AS id_1, t0.mark AS mark_2, t0.model AS model_3, t0.vin_number AS vin_number_4, t0.registration_number AS registration_number_5, t0.issue_year AS issue_year_6, t0.payment_amount AS payment_amount_7, t0.color AS color_8 FROM motorcycle t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 1.07 ms
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.password AS password_3, t0.user_number AS user_number_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.middle_name AS middle_name_7, t0.date_of_birth AS date_of_birth_8, t0.passport_number AS passport_number_9, t0.passport_id AS passport_id_10, t0.passport_issue_date AS passport_issue_date_11, t0.passport_issuing_authority AS passport_issuing_authority_12, t0.registration_address AS registration_address_13, t0.drivers_license_number AS drivers_license_number_14, t0.drivers_license_date AS drivers_license_date_15, t0.date_signing_contract AS date_signing_contract_16, t0.notes AS notes_17 FROM client t0 WHERE t0.id = ?
Parameters:
[
  218
]
10 1.24 ms
SELECT t0.id AS id_1, t0.mark AS mark_2, t0.model AS model_3, t0.vin_number AS vin_number_4, t0.registration_number AS registration_number_5, t0.issue_year AS issue_year_6, t0.payment_amount AS payment_amount_7, t0.color AS color_8 FROM motorcycle t0 WHERE t0.id = ?
Parameters:
[
  3
]
11 0.45 ms
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.password AS password_3, t0.user_number AS user_number_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.middle_name AS middle_name_7, t0.date_of_birth AS date_of_birth_8, t0.passport_number AS passport_number_9, t0.passport_id AS passport_id_10, t0.passport_issue_date AS passport_issue_date_11, t0.passport_issuing_authority AS passport_issuing_authority_12, t0.registration_address AS registration_address_13, t0.drivers_license_number AS drivers_license_number_14, t0.drivers_license_date AS drivers_license_date_15, t0.date_signing_contract AS date_signing_contract_16, t0.notes AS notes_17 FROM client t0 WHERE t0.id = ?
Parameters:
[
  11
]

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
FOS\UserBundle\Model\User No errors.
Sonata\UserBundle\Entity\BaseUser No errors.
App\Entity\AdmUser No errors.
FOS\UserBundle\Model\Group No errors.
Sonata\UserBundle\Entity\BaseGroup No errors.
App\Entity\Group No errors.
App\Entity\Reserve No errors.
App\Entity\Motorcycle No errors.
App\Entity\Client No errors.