Query Metrics
7
Database Queries
7
Different statements
14.60 ms
Query time
0
Invalid entities
26
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.04 ms (34.52%) |
1 |
DELETE FROM reset_password_request WHERE expires_at <= ?
Parameters:
[
"2026-01-06 17:10:50"
]
|
||||||||||||||||||||||||||||||||
|
4.63 ms (31.74%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
1.96 ms (13.44%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.user_type AS user_type_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.oauth_provider AS oauth_provider_8, t0.oauth_id AS oauth_id_9, t0.profile_picture_filename AS profile_picture_filename_10, t0.oauth_data AS oauth_data_11, t0.on_boarding_completed_at AS on_boarding_completed_at_12, t0.dob AS dob_13, t0.gender AS gender_14, t0.phone1 AS phone1_15, t0.phone2 AS phone2_16, t0.bio AS bio_17, t0.nickname AS nickname_18, t0.blocked AS blocked_19, t0.is_hybrid_recruiter AS is_hybrid_recruiter_20, t0.address AS address_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.employer_id AS employer_id_24, t25.id AS id_26, t25.name AS name_27, t25.suffix AS suffix_28, t25.title AS title_29, t25.npi_number AS npi_number_30, t25.phone_home AS phone_home_31, t25.phone_work AS phone_work_32, t25.phone_mobile AS phone_mobile_33, t25.cv_filename AS cv_filename_34, t25.country AS country_35, t25.state AS state_36, t25.city AS city_37, t25.zip_code AS zip_code_38, t25.street_address AS street_address_39, t25.desired_pay_rate AS desired_pay_rate_40, t25.pay_rate_hourly AS pay_rate_hourly_41, t25.pay_rate_daily AS pay_rate_daily_42, t25.desired_hour AS desired_hour_43, t25.desired_states AS desired_states_44, t25.availability_to_start AS availability_to_start_45, t25.willing_to_travel AS willing_to_travel_46, t25.preferred_patient_volume AS preferred_patient_volume_47, t25.release_authorization_date AS release_authorization_date_48, t25.ssn AS ssn_49, t25.dob AS dob_50, t25.country_of_birth AS country_of_birth_51, t25.state_of_birth AS state_of_birth_52, t25.city_of_birth AS city_of_birth_53, t25.release_and_authorization_accepted AS release_and_authorization_accepted_54, t25.application_certification_date AS application_certification_date_55, t25.risk_assessment AS risk_assessment_56, t25.health_assessment AS health_assessment_57, t25.cashback AS cashback_58, t25.notification_preferences AS notification_preferences_59, t25.average_point AS average_point_60, t25.skip_onboarding AS skip_onboarding_61, t25.created_at AS created_at_62, t25.updated_at AS updated_at_63, t25.user_id AS user_id_64, t25.profession_id AS profession_id_65, t66.id AS id_67, t66.company_name AS company_name_68, t66.speciality AS speciality_69, t66.membership_level AS membership_level_70, t66.rating AS rating_71, t66.is_verified AS is_verified_72, t66.created_at AS created_at_73, t66.updated_at AS updated_at_74, t66.user_id AS user_id_75, t0.recruiter_id AS recruiter_id_76 FROM b_user t0 LEFT JOIN b_provider t25 ON t25.user_id = t0.id LEFT JOIN b_recruiter t66 ON t66.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
"SUBASTAKOTI@GMAIL.COM"
]
|
||||||||||||||||||||||||||||||||
|
1.18 ms (8.10%) |
1 |
SELECT r0_.id AS id_0, r0_.selector AS selector_1, r0_.hashed_token AS hashed_token_2, r0_.requested_at AS requested_at_3, r0_.expires_at AS expires_at_4, r0_.user_id AS user_id_5 FROM reset_password_request r0_ WHERE r0_.user_id = ? ORDER BY r0_.requested_at DESC LIMIT 1
Parameters:
[ Symfony\Component\Uid\UuidV7 {#1360 : "0194a884-2b80-7107-81e5-3a47bab74add" } ] |
||||||||||||||||||||||||||||||||
|
0.76 ms (5.23%) |
1 |
INSERT INTO reset_password_request (selector, hashed_token, requested_at, expires_at, user_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "7UgmhxEP8IZMFEERkFsD" "3sl57Kd/+PpA66+mBAy2uJYXqjzFifcoRRJl9osFlho=" "2026-01-13 17:10:50" "2026-01-13 18:10:50" b"\x01ö¿ä+Çq\x07üÕ:G║ÀJ¦" ]
|
||||||||||||||||||||||||||||||||
|
0.70 ms (4.79%) |
1 |
SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0
Parameters:
[] |
||||||||||||||||||||||||||||||||
|
0.32 ms (2.18%) |
1 |
"START TRANSACTION"
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Config | 23 |
| App\Entity\User | 1 |
| App\Entity\Provider | 1 |
| App\Entity\ResetPasswordRequest | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Employer | No errors. |
| App\Entity\Provider | No errors. |
| App\Entity\Profession | No errors. |
| App\Entity\Recruiter | No errors. |
| App\Entity\Speciality | No errors. |
| App\Entity\Application | No errors. |
| App\Entity\ResetPasswordRequest | No errors. |
| App\Entity\Config | No errors. |