Symfony Profiler

[
  "route" => "app_recruiter_job_applications"
  "route_parameters" => [
    "_route" => "app_recruiter_job_applications"
    "_controller" => "App\Controller\Recruiter\JobController::applications"
    "id" => "1f0edd68-c055-6f8a-8be9-d11a55df1690"
  ]
  "request_uri" => "https://bill.flexzob.com/recruiter/jobs/1f0edd68-c055-6f8a-8be9-d11a55df1690/applications"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppUserAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppUserAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "HWI\Bundle\OAuthBundle\Security\Http\Authenticator\OAuthAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "HWI\Bundle\OAuthBundle\Security\Http\Authenticator\OAuthAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "use_savepoints" => true
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "locumuser"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "8.0.32"
    "defaultTableOptions" => []
    "dbname" => "test"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => b"\x1F\x0EdŸ\x12ÌdZ”)s$\x18ívÀ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "testrecruiter@flexzob.com"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "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"
  "params" => [
    1 => b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
    2 => b"\x1F\x0Edƒ\x12╦lbÉps$\x18Ýv└"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
    2 => b"\x01”Á^'€zÒ’Ò\x05»áŽÔ\x7F"
    3 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1322
      #uid: "0194c15e-2780-7ad2-92d2-05bbe18ed47f"
      toBase58: "1CKnGV8njazvRuhbQs7rxv"
      toBase32: "01JK0NW9W0FB995MG5QFGRXN3Z"
      time: "2025-02-01 11:56:00.768000 UTC"
    }
    2 => Symfony\Component\Uid\UuidV6 {#1313
      #uid: "1f0edd68-c055-6f8a-8be9-d11a55df1690"
      toBase58: "4qSZ7ApCzUBgzaRqFFaRZh"
      toBase32: "0Z1VEPHG2NDY58QTEH39AXY5MG"
      time: "2026-01-10 03:43:37.643201 UTC"
    }
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => b"\x1F\x0EdŸ\x12ÌdZ”)s$\x18ívÀ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => b"\x1F\x0EdŸ\x12ÌdZ”)s$\x18ívÀ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => b"\x1F\x0EdŸ\x12ÌdZ”)s$\x18ívÀ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => b"\x1F\x0EÝmR\x1A`\f£Ä¿Œ TTq"
    2 => b"\x1F\x0E╩ìæÁj\x1AÅ\x1F7═\x0F>b\x03"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => b"\x1F\x0E╩ìæÁj\x1AÅ\x1F7═\x0F>b\x03"
    2 => b"\x1F\x0EÝmR\x1A`\f£Ä¿Œ TTq"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => b"\x1F\x0E¦h└UoèïÚÐ\x1AU▀\x16É"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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"
  "params" => [
    1 => "EMPLOYER"
    2 => 0
    3 => b"\x1F\x0EdŸ\x12ÌdZ”)s$\x18ívÀ"
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => b"\x1F\x0EdŸ\x12ÌdZ”)s$\x18ívÀ"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]