Redirect 302 redirect from GET @app_recruiter_job_show (904d5e)

GET https://bill.flexzob.com/recruiter/jobs/1f0edd68-c055-6f8a-8be9-d11a55df1690/applications

Query Metrics

15 Database Queries
15 Different statements
17.80 ms Query time
0 Invalid entities
35 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.52 ms
(14.15%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.employment_type AS employment_type_3, t0.company AS company_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.location AS location_7, t0.location_type AS location_type_8, t0.description AS description_9, t0.user_id AS user_id_10 FROM b_provider_experience t0 WHERE t0.user_id = ?
Parameters:
[
  b"\x1F\x0E\x12ÌdZ”)s$\x18ívÀ"
]
1.60 ms
(8.97%)
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.id = ?
Parameters:
[
  b"\x1F\x0E\x12ÌdZ”)s$\x18ívÀ"
]
1.29 ms
(7.26%)
1
SELECT b0_.id AS id_0, b0_.status AS status_1, b0_.applied_at AS applied_at_2, b0_.hired_at AS hired_at_3, b0_.document_requested_at AS document_requested_at_4, b0_.document_provided_at AS document_provided_at_5, b0_.one_file_requested_at AS one_file_requested_at_6, b0_.one_file_provided_at AS one_file_provided_at_7, b0_.contract_sent_at AS contract_sent_at_8, b0_.contract_file_name AS contract_file_name_9, b0_.contract_signed_at AS contract_signed_at_10, b0_.contract_signed_file_name AS contract_signed_file_name_11, b0_.`rank` AS rank_12, b0_.archived_at AS archived_at_13, b0_.is_archived AS is_archived_14, b0_.created_at AS created_at_15, b0_.updated_at AS updated_at_16, b0_.employer_id AS employer_id_17, b0_.recruiter_id AS recruiter_id_18, b0_.provider_id AS provider_id_19, b0_.job_id AS job_id_20, b0_.interview_id AS interview_id_21 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id WHERE b0_.is_archived = 0 AND b0_.employer_id = ? AND b0_.job_id = ? ORDER BY b0_.id DESC
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1322
    __toString(): "0194c15e-2780-7ad2-92d2-05bbe18ed47f"
  }
  Symfony\Component\Uid\UuidV6 {#1313
    __toString(): "1f0edd68-c055-6f8a-8be9-d11a55df1690"
  }
]
1.23 ms
(6.91%)
1
SELECT t0.id AS id_1, t0.notification_type AS notification_type_2, t0.user_type AS user_type_3, t0.message AS message_4, t0.seen AS seen_5, t0.extra_data AS extra_data_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM b_notification t0 WHERE t0.user_type = ? AND t0.seen = ? AND t0.user_id = ? ORDER BY t0.created_at DESC LIMIT 5
Parameters:
[
  "EMPLOYER"
  0
  b"\x1F\x0E\x12ÌdZ”)s$\x18ívÀ"
]
1.21 ms
(6.82%)
1
SELECT t0.id AS id_1, t0.carrier AS carrier_2, t0.policy_number AS policy_number_3, t0.amount AS amount_4, t0.state AS state_5, t0.city AS city_6, t0.effective_date AS effective_date_7, t0.expiration_date AS expiration_date_8, t0.user_id AS user_id_9 FROM b_provider_insurance t0 WHERE t0.user_id = ?
Parameters:
[
  b"\x1F\x0E\x12ÌdZ”)s$\x18ívÀ"
]
1.16 ms
(6.53%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.applied_at AS applied_at_3, t0.hired_at AS hired_at_4, t0.document_requested_at AS document_requested_at_5, t0.document_provided_at AS document_provided_at_6, t0.one_file_requested_at AS one_file_requested_at_7, t0.one_file_provided_at AS one_file_provided_at_8, t0.contract_sent_at AS contract_sent_at_9, t0.contract_file_name AS contract_file_name_10, t0.contract_signed_at AS contract_signed_at_11, t0.contract_signed_file_name AS contract_signed_file_name_12, t0.`rank` AS rank_13, t0.archived_at AS archived_at_14, t0.is_archived AS is_archived_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.employer_id AS employer_id_18, t0.recruiter_id AS recruiter_id_19, t0.provider_id AS provider_id_20, t0.job_id AS job_id_21, t0.interview_id AS interview_id_22 FROM b_application t0 WHERE t0.job_id = ? AND t0.is_archived = ? ORDER BY t0.id DESC
Parameters:
[
  b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
  0
]
1.15 ms
(6.46%)
1
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É"
]
1.13 ms
(6.35%)
1
SELECT b0_.status AS status_0, COUNT(b0_.id) AS sclr_1 FROM b_application b0_ WHERE b0_.job_id = ? AND b0_.archived_at IS NULL GROUP BY b0_.status
Parameters:
[
  b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
]
1.11 ms
(6.25%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.applied_at AS applied_at_3, t0.hired_at AS hired_at_4, t0.document_requested_at AS document_requested_at_5, t0.document_provided_at AS document_provided_at_6, t0.one_file_requested_at AS one_file_requested_at_7, t0.one_file_provided_at AS one_file_provided_at_8, t0.contract_sent_at AS contract_sent_at_9, t0.contract_file_name AS contract_file_name_10, t0.contract_signed_at AS contract_signed_at_11, t0.contract_signed_file_name AS contract_signed_file_name_12, t0.`rank` AS rank_13, t0.archived_at AS archived_at_14, t0.is_archived AS is_archived_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.employer_id AS employer_id_18, t0.recruiter_id AS recruiter_id_19, t0.provider_id AS provider_id_20, t0.job_id AS job_id_21, t0.interview_id AS interview_id_22 FROM b_application t0 WHERE t0.job_id = ? AND t0.employer_id = ? AND t0.is_archived = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
  b"\x01”Á^'€zÒ’Ò\x05»áŽÔ\x7F"
  0
]
0.98 ms
(5.53%)
1
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\x0E\x12╦lbÉps$\x18Ýv└"
]
0.95 ms
(5.34%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.provided_at AS provided_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.provider_id AS provider_id_6, t0.requested_by_id AS requested_by_id_7, t0.application_id AS application_id_8, t0.document_id AS document_id_9 FROM b_document_request t0 WHERE t0.provider_id = ? AND t0.application_id = ?
Parameters:
[
  b"\x1F\x0E╩ìæÁj\x1AÅ\x1F7═\x0F>b\x03"
  b"\x1F\x0EÝmR\x1A`\f£Ä¿Œ TTq"
]
0.92 ms
(5.17%)
1
SELECT t0.id AS id_1, t0.notification_type AS notification_type_2, t0.user_type AS user_type_3, t0.message AS message_4, t0.seen AS seen_5, t0.extra_data AS extra_data_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM b_notification t0 WHERE t0.user_id = ? AND t0.seen = ?
Parameters:
[
  b"\x1F\x0E\x12ÌdZ”)s$\x18ívÀ"
  0
]
0.89 ms
(5.01%)
1
SELECT t0.id AS id_1, t0.message AS message_2, t0.reviewed_by AS reviewed_by_3, t0.point AS point_4, t0.professionalism AS professionalism_5, t0.quality AS quality_6, t0.communication AS communication_7, t0.emotional_intelligence AS emotional_intelligence_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.provider_id AS provider_id_11, t0.employer_id AS employer_id_12, t0.recruiter_id AS recruiter_id_13, t0.application_id AS application_id_14 FROM b_review t0 WHERE t0.application_id = ? AND t0.provider_id = ? LIMIT 1
Parameters:
[
  b"\x1F\x0EÝmR\x1A`\f£Ä¿Œ TTq"
  b"\x1F\x0E╩ìæÁj\x1AÅ\x1F7═\x0F>b\x03"
]
0.86 ms
(4.81%)
1
SELECT t0.id AS id_1, t0.degree AS degree_2, t0.school AS school_3, t0.field_of_study AS field_of_study_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.grade AS grade_7, t0.description AS description_8, t0.country AS country_9, t0.state AS state_10, t0.city AS city_11, t0.user_id AS user_id_12 FROM b_provider_education t0 WHERE t0.user_id = ?
Parameters:
[
  b"\x1F\x0E\x12ÌdZ”)s$\x18ívÀ"
]
0.79 ms
(4.44%)
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:
[]

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\Notification 4
App\Entity\User 2
App\Entity\Provider 1
App\Entity\Recruiter 1
App\Entity\Job 1
App\Entity\Employer 1
App\Entity\JobRecruiter 1
App\Entity\Application 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.
App\Entity\Interview No errors.
App\Entity\DocumentRequest No errors.
App\Entity\Review No errors.
App\Entity\Education No errors.
App\Entity\Experience No errors.
App\Entity\Insurance No errors.
App\Entity\Document No errors.
App\Entity\Config No errors.
App\Entity\Notification No errors.