Query Metrics
5
Database Queries
5
Different statements
3.41 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.89 ms (26.05%) |
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:
[
7
]
|
0.84 ms (24.53%) |
1 |
SELECT c0_.id AS id_0, c0_.phone AS phone_1, c0_.password AS password_2, c0_.user_number AS user_number_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.middle_name AS middle_name_6, c0_.date_of_birth AS date_of_birth_7, c0_.passport_number AS passport_number_8, c0_.passport_id AS passport_id_9, c0_.passport_issue_date AS passport_issue_date_10, c0_.passport_issuing_authority AS passport_issuing_authority_11, c0_.registration_address AS registration_address_12, c0_.drivers_license_number AS drivers_license_number_13, c0_.drivers_license_date AS drivers_license_date_14, c0_.date_signing_contract AS date_signing_contract_15, c0_.notes AS notes_16, c0_.created_at AS created_at_17, c0_.admin_id AS admin_id_18 FROM client c0_ WHERE c0_.id IN (?) ORDER BY c0_.id DESC
Parameters:
[ [ 561 560 559 558 557 556 555 554 553 552 551 550 549 548 547 546 545 544 543 542 541 540 539 538 537 536 535 534 533 532 531 530 ] ] |
0.70 ms (20.54%) |
1 |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM client c0_
Parameters:
[] |
0.51 ms (14.94%) |
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:
[
7
]
|
0.48 ms (13.94%) |
1 |
SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM client c0_ ORDER BY c0_.id DESC LIMIT 32
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 |
---|---|
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\Client | No errors. |