Query Metrics
3
Database Queries
3
Different statements
3.54 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.35 ms |
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.id = ?
Parameters:
[
b"\x1F\x0EdŸ\x12ÌdZ”)s$\x18ívÀ"
]
|
||||||||||||||||||||||
| 2 | 1.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.country AS country_5, t0.state AS state_6, t0.city AS city_7, t0.street_address AS street_address_8, t0.expiration_date AS expiration_date_9, t0.highlight AS highlight_10, t0.schedule AS schedule_11, t0.start_date AS start_date_12, t0.year_of_experience AS year_of_experience_13, t0.pay_rate AS pay_rate_14, t0.work_type AS work_type_15, t0.need AS need_16, t0.pay_rate_hourly AS pay_rate_hourly_17, t0.pay_rate_daily AS pay_rate_daily_18, t0.annual_salary AS annual_salary_19, t0.monthly_salary AS monthly_salary_20, t0.salary_type AS salary_type_21, t0.blocked AS blocked_22, t0.job_id AS job_id_23, t0.verified AS verified_24, t0.is_mediated AS is_mediated_25, t0.`rank` AS rank_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.user_id AS user_id_29, t0.employer_id AS employer_id_30, t0.profession_id AS profession_id_31, t0.speciality_id AS speciality_id_32, t0.assigned_recruiter_id AS assigned_recruiter_id_33 FROM b_job t0 WHERE t0.id = ?
Parameters:
[
b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
]
|
||||||||||||||||||||||
| 3 | 1.06 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.commission_rate AS commission_rate_3, t0.assigned_at AS assigned_at_4, t0.job_id AS job_id_5, t0.recruiter_id AS recruiter_id_6 FROM b_job_recruiter t0 WHERE t0.job_id = ? AND t0.recruiter_id = ? LIMIT 1
Parameters:
[ b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É" b"\x1F\x0Edƒ\x12╦lbÉps$\x18Ýv└" ]
|
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\User | 2 |
| App\Entity\Provider | 1 |
| App\Entity\Recruiter | 1 |
| App\Entity\Job | 1 |
| App\Entity\Employer | 1 |
| App\Entity\JobRecruiter | 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\JobRecruiter | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Job | No errors. |