Query Metrics
47
Database Queries
7
Different statements
16.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.63 ms (58.33%) |
32 |
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, t0.created_at AS created_at_18, t0.admin_id AS admin_id_19 FROM client t0 WHERE t0.id = ?
Parameters:
[
911
]
|
|
2.95 ms (17.89%) |
10 |
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, t0.mileage AS mileage_9, t0.rental_price_id AS rental_price_id_10 FROM motorcycle t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
1.26 ms (7.65%) |
1 |
SELECT DISTINCT r0_.id AS id_0, r0_.start_date AS start_date_1, r0_.id AS id_2 FROM reserve r0_ WHERE r0_.status = ? ORDER BY r0_.start_date ASC, r0_.id ASC LIMIT 32
Parameters:
[
2
]
|
|
1.09 ms (6.59%) |
1 |
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM reserve r0_ WHERE r0_.status = ?
Parameters:
[
2
]
|
|
0.65 ms (3.91%) |
1 |
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_.start_rent_mileage AS start_rent_mileage_6, r0_.end_rent_mileage AS end_rent_mileage_7, r0_.created_at AS created_at_8, r0_.motorcycle_id AS motorcycle_id_9, r0_.client_id AS client_id_10, r0_.admin_id AS admin_id_11 FROM reserve r0_ WHERE r0_.status = ? AND r0_.id IN (?) ORDER BY r0_.start_date ASC, r0_.id ASC
Parameters:
[ 2 [ 3085 3025 3055 3056 3069 3072 3073 3081 3082 3103 3088 3066 3067 3070 3074 3092 3093 3060 3061 3062 3063 3101 3107 3108 3109 3110 3102 3076 3038 3077 3078 3105 ] ] |
|
0.52 ms (3.13%) |
1 |
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, t0.middle_name AS middle_name_35, t0.job_title_type AS job_title_type_36, t0.proxy_number AS proxy_number_37, t0.proxy_date AS proxy_date_38 FROM adm_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
8
]
|
|
0.41 ms (2.49%) |
1 |
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:
[
8
]
|
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. |
| App\Entity\Reserve | No errors. |
| FOS\UserBundle\Model\Group | No errors. |
| Sonata\UserBundle\Entity\BaseGroup | No errors. |
| App\Entity\Group | No errors. |
| App\Entity\Motorcycle | No errors. |
| App\Entity\Equipment | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\RentalPrice | No errors. |
| App\Entity\ServiceHistory | No errors. |