Query Metrics
5
Database Queries
3
Different statements
57.27 ms
Query time
2
Invalid entities
13
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
25.58 ms (44.67%) |
3 |
SELECT t0.name AS name_1, t0.secret AS secret_2, t0.redirect_uris AS redirect_uris_3, t0.grants AS grants_4, t0.scopes AS scopes_5, t0.active AS active_6, t0.allow_plain_text_pkce AS allow_plain_text_pkce_7, t0.identifier AS identifier_8, t0.is_confidential AS is_confidential_9, t0.created_at AS created_at_10, t0.uuid AS uuid_11, t0.user_id AS user_id_12, t13.id AS id_14, t13.name AS name_15, t13.description AS description_16, t13.allowed_ips AS allowed_ips_17, t13.token_expiry_policy AS token_expiry_policy_18, t13.logo_url AS logo_url_19, t13.website AS website_20, t13.client_id AS client_id_21 FROM oauth2_client t0 LEFT JOIN oauth2_client_profile t13 ON t13.client_id = t0.identifier WHERE t0.identifier = ? LIMIT 1
Parameters:
[
"b4c34e1a9f96b5931f15dbf698165475"
]
|
|
20.33 ms (35.51%) |
1 |
SELECT t0.id AS id_4, t0.contact_number AS contact_number_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.date_of_birth AS date_of_birth_8, t0.thumbnail AS thumbnail_9, t0.profile_cover_image AS profile_cover_image_10, t0.auth_code AS auth_code_11, t0.is_two_factor_enabled AS is_two_factor_enabled_12, t0.profile_photo AS profile_photo_13, t0.profile_cover_photo AS profile_cover_photo_14, t0.account_status AS account_status_15, t0.account_confirmed_at AS account_confirmed_at_16, t0.bio AS bio_17, t0.address AS address_18, t0.city AS city_19, t0.marital_status AS marital_status_20, t0.country AS country_21, t0.nationality AS nationality_22, t0.status AS status_23, t0.online_status AS online_status_24, t0.phone_numbers AS phone_numbers_25, t0.active_role AS active_role_26, t0.active_layout AS active_layout_27, t0.active_theme AS active_theme_28, t0.email AS email_29, t0.password AS password_30, t0.is_verified AS is_verified_31, t0.is_logged_in AS is_logged_in_32, t0.gender AS gender_33, t0.first_name AS first_name_34, t0.last_name AS last_name_35, t0.other_names AS other_names_36, t0.is_deleted AS is_deleted_37, t0.deleted_at AS deleted_at_38, t0.documents AS documents_39, t0.employee_data_id AS employee_data_id_40, t0.department_id AS department_id_41, t0.created_by_id AS created_by_id_42, t0.updated_by_id AS updated_by_id_43, t0.user_type, t3.index_number AS index_number_44, t3.academic_year AS academic_year_45, t3.semester AS semester_46, t3.department_code AS department_code_47, t3.program_code AS program_code_48, t3.year_level AS year_level_49, t3.credit_hours AS credit_hours_50, t3.current_balance AS current_balance_51, t3.financial_aid_amount AS financial_aid_amount_52, t3.metadata AS metadata_53, t3.residency_status AS residency_status_54 FROM core_user t0 LEFT JOIN core_user_employee t1 ON t0.id = t1.id LEFT JOIN core_user_admin t2 ON t0.id = t2.id LEFT JOIN core_user_student t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
"f8583a61-a8e1-4a19-aa79-829409514d6a"
]
|
|
11.35 ms (19.82%) |
1 |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.value AS value_3, t0.type AS type_4, t0.required AS required_5 FROM fbeen_settings t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| logger | doctrine.dbal.logger_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| logger | doctrine.orm.logger_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Fbeen\SettingsBundle\Entity\Setting | 9 |
| Boab\CoreBundle\Entity\Client | 1 |
| Boab\CoreBundle\Entity\User | 1 |
| App\Entity\Employee\EmployeeBioData | 1 |
| Boab\CoreBundle\Entity\OAuth2ClientProfile | 1 |
logger entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| Boab\CoreBundle\Entity\User | No errors. |
| Boab\CoreBundle\Entity\Role | No errors. |
| Fbeen\SettingsBundle\Entity\Setting | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AbstractClient | No errors. |
| Boab\CoreBundle\Entity\Client | No errors. |
| Boab\CoreBundle\Entity\OAuth2ClientProfile | No errors. |
| App\Entity\Employee\Employee |
|
| Boab\CoreBundle\Entity\Admin | No errors. |
| Boab\StudentBundle\Entity\Student |
|
| App\Entity\Employee\EmployeeBioData | No errors. |
| App\Entity\Department\Department | No errors. |
| Boab\CoreBundle\Entity\OAuth2UserConsent | No errors. |
| App\Entity\Chat\Message | No errors. |
| App\Entity\Chat\UserChannel | No errors. |
| Boab\CoreBundle\Entity\UserPermission | No errors. |
logger entity manager
No loaded entities.