Symfony Profiler

[
  "route" => "app_provider_dashboard"
  "route_parameters" => [
    "_route" => "app_provider_dashboard"
    "_controller" => "App\Controller\Provider\DashboardController::index"
  ]
  "request_uri" => "https://bill.flexzob.com/provider/dashboard"
  "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.stripe_customer_id AS stripe_customer_id_15, t0.stripe_connect_id AS stripe_connect_id_16, t0.stripe_account_status AS stripe_account_status_17, t0.subscription_status AS subscription_status_18, t0.subscription_ends_at AS subscription_ends_at_19, t0.custom_fee_structure AS custom_fee_structure_20, t0.phone1 AS phone1_21, t0.phone2 AS phone2_22, t0.bio AS bio_23, t0.nickname AS nickname_24, t0.blocked AS blocked_25, t0.mfa_code AS mfa_code_26, t0.mfa_expires_at AS mfa_expires_at_27, t0.is_hybrid_recruiter AS is_hybrid_recruiter_28, t0.address AS address_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.employer_id AS employer_id_32, t0.staffing_agency_id AS staffing_agency_id_33, t35.id AS id_34, t35.name AS name_36, t35.suffix AS suffix_37, t35.title AS title_38, t35.npi_number AS npi_number_39, t35.phone_home AS phone_home_40, t35.phone_work AS phone_work_41, t35.phone_mobile AS phone_mobile_42, t35.cv_filename AS cv_filename_43, t35.country AS country_44, t35.state AS state_45, t35.city AS city_46, t35.zip_code AS zip_code_47, t35.street_address AS street_address_48, t35.desired_pay_rate AS desired_pay_rate_49, t35.pay_rate_hourly AS pay_rate_hourly_50, t35.pay_rate_daily AS pay_rate_daily_51, t35.desired_hour AS desired_hour_52, t35.desired_states AS desired_states_53, t35.availability_to_start AS availability_to_start_54, t35.willing_to_travel AS willing_to_travel_55, t35.preferred_patient_volume AS preferred_patient_volume_56, t35.release_authorization_date AS release_authorization_date_57, t35.ssn AS ssn_58, t35.dob AS dob_59, t35.country_of_birth AS country_of_birth_60, t35.state_of_birth AS state_of_birth_61, t35.city_of_birth AS city_of_birth_62, t35.release_and_authorization_accepted AS release_and_authorization_accepted_63, t35.application_certification_date AS application_certification_date_64, t35.risk_assessment AS risk_assessment_65, t35.health_assessment AS health_assessment_66, t35.cashback AS cashback_67, t35.notification_preferences AS notification_preferences_68, t35.average_point AS average_point_69, t35.skip_onboarding AS skip_onboarding_70, t35.professional_references AS professional_references_71, t35.rewards_points AS rewards_points_72, t35.created_at AS created_at_73, t35.updated_at AS updated_at_74, t35.user_id AS user_id_75, t35.profession_id AS profession_id_76, t78.id AS id_77, t78.company_name AS company_name_79, t78.speciality AS speciality_80, t78.membership_level AS membership_level_81, t78.rating AS rating_82, t78.is_verified AS is_verified_83, t78.stripe_connect_account_id AS stripe_connect_account_id_84, t78.stripe_account_status AS stripe_account_status_85, t78.created_at AS created_at_86, t78.updated_at AS updated_at_87, t78.user_id AS user_id_88, t90.id AS id_89, t90.balance AS balance_91, t90.updated_at AS updated_at_92, t90.user_id AS user_id_93, t0.membership_tier_id AS membership_tier_id_94, t0.recruiter_id AS recruiter_id_95, t0.dtype FROM b_user t0 LEFT JOIN b_provider t35 ON t35.user_id = t0.id LEFT JOIN b_recruiter t78 ON t78.user_id = t0.id LEFT JOIN b_credit_wallet t90 ON t90.user_id = t0.id WHERE t0.id = ? AND t0.dtype IN ('user')"
  "params" => [
    1 => b"\x1F\x12\x14À‘ƒc¾„ž/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "testprovider@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" => "App\EventSubscriber\MfaSubscriber::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.request"
  "listener" => "App\EventSubscriber\SubscriptionCheckSubscriber::onKernelRequest"
]

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

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

[
  "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.name AS name_2, t0.profession_id AS profession_id_3 FROM b_speciality t0 INNER JOIN provider_speciality ON t0.id = provider_speciality.speciality_id WHERE provider_speciality.provider_id = ?"
  "params" => [
    1 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.employer_status AS employer_status_1, t0.recruiter_status AS recruiter_status_2, t0.staffing_agency_status AS staffing_agency_status_3, t0.id AS id_4, t0.status AS status_5, t0.applied_at AS applied_at_6, t0.hired_at AS hired_at_7, t0.document_requested_at AS document_requested_at_8, t0.document_provided_at AS document_provided_at_9, t0.one_file_requested_at AS one_file_requested_at_10, t0.one_file_provided_at AS one_file_provided_at_11, t0.contract_sent_at AS contract_sent_at_12, t0.contract_file_name AS contract_file_name_13, t0.contract_url AS contract_url_14, t0.contract_signed_at AS contract_signed_at_15, t0.contract_signed_file_name AS contract_signed_file_name_16, t0.`rank` AS rank_17, t0.archived_at AS archived_at_18, t0.is_rewards_awarded AS is_rewards_awarded_19, t0.is_archived AS is_archived_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.employer_id AS employer_id_23, t0.staffing_agency_id AS staffing_agency_id_24, t0.recruiter_id AS recruiter_id_25, t0.provider_id AS provider_id_26, t0.job_id AS job_id_27, t0.interview_id AS interview_id_28 FROM b_application t0 WHERE t0.provider_id = ?"
  "params" => [
    1 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34, b0_.user_id AS user_id_35, b0_.employer_id AS employer_id_36, b0_.staffing_agency_id AS staffing_agency_id_37, b0_.profession_id AS profession_id_38, b0_.speciality_id AS speciality_id_39, b0_.assigned_recruiter_id AS assigned_recruiter_id_40 FROM b_job b0_ WHERE b0_.status = ? AND b0_.archived_at IS NULL AND b0_.expiration_date >= ? AND (b0_.profession_id = ? OR b0_.state IN (?)) ORDER BY b0_.created_at DESC LIMIT 50"
  "params" => [
    1 => "published"
    2 => "2026-04-20 12:55:03"
    3 => b"\x01•3‡}yw¦»øù‘x\vXR"
    4 => "AK"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x01•3‡}yw¦»øù‘x\vXR"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.ip_address AS ip_address_2, p0_.user_agent AS user_agent_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.viewed_provider_id AS viewed_provider_id_6, p0_.viewer_id AS viewer_id_7 FROM profile_analytics p0_ WHERE p0_.viewed_provider_id = ? AND p0_.created_at >= ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV6 {#1172
      #uid: "1f1214c0-8b40-6d9e-80db-2ff2d72f559a"
      toBase58: "4qXmo887yVoNdsWc9uCkFj"
      toBase32: "0Z28AC12T0DPF81PSFYBBJYNCT"
      time: "2026-03-16 15:23:07.244483 UTC"
    }
    2 => "2026-04-01 00:00:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.ip_address AS ip_address_2, p0_.user_agent AS user_agent_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.viewed_provider_id AS viewed_provider_id_6, p0_.viewer_id AS viewer_id_7 FROM profile_analytics p0_ WHERE p0_.viewed_provider_id = ? AND p0_.created_at >= ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV6 {#1172
      #uid: "1f1214c0-8b40-6d9e-80db-2ff2d72f559a"
      toBase58: "4qXmo887yVoNdsWc9uCkFj"
      toBase32: "0Z28AC12T0DPF81PSFYBBJYNCT"
      time: "2026-03-16 15:23:07.244483 UTC"
    }
    2 => "2026-03-01 00:00:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.employer_status AS employer_status_1, t0.recruiter_status AS recruiter_status_2, t0.staffing_agency_status AS staffing_agency_status_3, t0.id AS id_4, t0.status AS status_5, t0.applied_at AS applied_at_6, t0.hired_at AS hired_at_7, t0.document_requested_at AS document_requested_at_8, t0.document_provided_at AS document_provided_at_9, t0.one_file_requested_at AS one_file_requested_at_10, t0.one_file_provided_at AS one_file_provided_at_11, t0.contract_sent_at AS contract_sent_at_12, t0.contract_file_name AS contract_file_name_13, t0.contract_url AS contract_url_14, t0.contract_signed_at AS contract_signed_at_15, t0.contract_signed_file_name AS contract_signed_file_name_16, t0.`rank` AS rank_17, t0.archived_at AS archived_at_18, t0.is_rewards_awarded AS is_rewards_awarded_19, t0.is_archived AS is_archived_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.employer_id AS employer_id_23, t0.staffing_agency_id AS staffing_agency_id_24, t0.recruiter_id AS recruiter_id_25, t0.provider_id AS provider_id_26, t0.job_id AS job_id_27, t0.interview_id AS interview_id_28 FROM b_application t0 WHERE t0.provider_id = ?"
  "params" => [
    1 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`rank` AS rank_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5, t0.job_id AS job_id_6 FROM b_bookmark t0 WHERE t0.user_id = ? ORDER BY t0.id DESC"
  "params" => [
    1 => b"\x1F\x12\x14À‘ƒc¾„ž/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.text AS text_2, t0.seen AS seen_3, t0.attachment AS attachment_4, t0.subject AS subject_5, t0.is_draft AS is_draft_6, t0.saved_at AS saved_at_7, t0.sent_at AS sent_at_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.is_forwarded AS is_forwarded_11, t0.original_subject AS original_subject_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.parent_id AS parent_id_15, t0.sender_id AS sender_id_16, t0.receiver_id AS receiver_id_17, t0.employer_id AS employer_id_18, t0.recruiter_id AS recruiter_id_19, t0.job_uuid AS job_uuid_20, t0.staffing_agency_id AS staffing_agency_id_21, t0.application_id AS application_id_22 FROM b_message t0 WHERE t0.receiver_id = ? ORDER BY t0.id DESC LIMIT 10"
  "params" => [
    1 => b"\x1F\x12\x14À‘ƒc¾„ž/ò×/Uš"
  ]
  "types" => [
    1 => 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 = ? ORDER BY t0.id DESC LIMIT 5"
  "params" => [
    1 => b"\x1F\x12\x14À‘ƒc¾„ž/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34, b0_.user_id AS user_id_35, b0_.employer_id AS employer_id_36, b0_.staffing_agency_id AS staffing_agency_id_37, b0_.profession_id AS profession_id_38, b0_.speciality_id AS speciality_id_39, b0_.assigned_recruiter_id AS assigned_recruiter_id_40 FROM b_job b0_ WHERE b0_.status = ? AND b0_.archived_at IS NULL AND b0_.expiration_date >= ? AND (b0_.profession_id = ? OR b0_.state IN (?)) ORDER BY b0_.created_at DESC LIMIT 5"
  "params" => [
    1 => "published"
    2 => "2026-04-20 12:55:03"
    3 => b"\x01•3‡}yw¦»øù‘x\vXR"
    4 => "AK"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.employer_status AS employer_status_1, t0.recruiter_status AS recruiter_status_2, t0.staffing_agency_status AS staffing_agency_status_3, t0.id AS id_4, t0.status AS status_5, t0.applied_at AS applied_at_6, t0.hired_at AS hired_at_7, t0.document_requested_at AS document_requested_at_8, t0.document_provided_at AS document_provided_at_9, t0.one_file_requested_at AS one_file_requested_at_10, t0.one_file_provided_at AS one_file_provided_at_11, t0.contract_sent_at AS contract_sent_at_12, t0.contract_file_name AS contract_file_name_13, t0.contract_url AS contract_url_14, t0.contract_signed_at AS contract_signed_at_15, t0.contract_signed_file_name AS contract_signed_file_name_16, t0.`rank` AS rank_17, t0.archived_at AS archived_at_18, t0.is_rewards_awarded AS is_rewards_awarded_19, t0.is_archived AS is_archived_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.employer_id AS employer_id_23, t0.staffing_agency_id AS staffing_agency_id_24, t0.recruiter_id AS recruiter_id_25, t0.provider_id AS provider_id_26, t0.job_id AS job_id_27, t0.interview_id AS interview_id_28 FROM b_application t0 WHERE t0.provider_id = ? ORDER BY t0.id DESC LIMIT 5"
  "params" => [
    1 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.employer_status AS employer_status_1, t0.recruiter_status AS recruiter_status_2, t0.staffing_agency_status AS staffing_agency_status_3, t0.id AS id_4, t0.status AS status_5, t0.applied_at AS applied_at_6, t0.hired_at AS hired_at_7, t0.document_requested_at AS document_requested_at_8, t0.document_provided_at AS document_provided_at_9, t0.one_file_requested_at AS one_file_requested_at_10, t0.one_file_provided_at AS one_file_provided_at_11, t0.contract_sent_at AS contract_sent_at_12, t0.contract_file_name AS contract_file_name_13, t0.contract_url AS contract_url_14, t0.contract_signed_at AS contract_signed_at_15, t0.contract_signed_file_name AS contract_signed_file_name_16, t0.`rank` AS rank_17, t0.archived_at AS archived_at_18, t0.is_rewards_awarded AS is_rewards_awarded_19, t0.is_archived AS is_archived_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.employer_id AS employer_id_23, t0.staffing_agency_id AS staffing_agency_id_24, t0.recruiter_id AS recruiter_id_25, t0.provider_id AS provider_id_26, t0.job_id AS job_id_27, t0.interview_id AS interview_id_28 FROM b_application t0 WHERE t0.provider_id = ? AND t0.archived_at IS NULL"
  "params" => [
    1 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT b0_.status AS status_0, COUNT(b0_.id) AS sclr_1 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id WHERE b0_.provider_id = ? AND b0_.archived_at IS NULL GROUP BY b0_.status"
  "params" => [
    1 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    \r\n
                    SELECT t.* \r\n
                    FROM to_do t\r\n
                    WHERE HEX(t.provider_id) = ?\r\n
                    AND t.is_completed = 0\r\n
                    ORDER BY t.created_at DESC\r\n
                
    """
  "params" => [
    1 => "1F1214C08B406D9E80DB2FF2D72F559A"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13žH…o¼ @5¤8N8Ä"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13zÕ­ie˜¥é탮«Š\x18"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13zeé\x01e\x08­¤E›B±\x0EÑ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13zeé\x01bL©€E›B±\x0EÑ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13zeé\x00o|†~E›B±\x0EÑ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13zeé\x00lŽ®rE›B±\x0EÑ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13`‰ï5k@£\x1Ds\x1A­ÜQo"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13`‰ï5iVž\x19s\x1A­ÜQo"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13`‰ï5g€…Gs\x1A­ÜQo"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13`‰ï5dؤís\x1A­ÜQo"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;îw*cÂüiS‗┘Î▀ü"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;~±▒gnÆkíÉx^ë "
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;|žxk0–]·X\x10]‹Ù"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;|žxiŒœç·X\x10]‹Ù"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;|žxgÔ´-·X\x10]‹Ù"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;|×xf\x12ü\x06ÀX\x10]ï┘"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"""
      \x1F\x13;z9ðj"╗ýد·\n
      `\x14
      """
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;kƒ\x00i@©ÆÙa\x10\x1F\n³"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"""
      \x1F\x13;kƒ\x01`„£öÙa\x10\x1F\n
      ³
      """
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;kƒ\x00mÜ‚\x0EÙa\x10\x1F\n³"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13;kƒ\x00k\x02«\x14Ùa\x10\x1F\n³"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.provided_at AS provided_at_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.provider_id AS provider_id_5, b0_.requested_by_id AS requested_by_id_6, b0_.application_id AS application_id_7, b0_.document_id AS document_id_8 FROM b_document_request b0_ LEFT JOIN b_application b1_ ON b0_.application_id = b1_.id WHERE b0_.provided_at IS NULL AND (b0_.provider_id = ? OR b1_.provider_id = ?) ORDER BY b0_.created_at DESC"
  "params" => [
    1 => Symfony\Component\Uid\UuidV6 {#1172
      #uid: "1f1214c0-8b40-6d9e-80db-2ff2d72f559a"
      toBase58: "4qXmo887yVoNdsWc9uCkFj"
      toBase32: "0Z28AC12T0DPF81PSFYBBJYNCT"
      time: "2026-03-16 15:23:07.244483 UTC"
    }
    2 => Symfony\Component\Uid\UuidV6 {#1172}
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT b0_.employer_status AS employer_status_0, b0_.recruiter_status AS recruiter_status_1, b0_.staffing_agency_status AS staffing_agency_status_2, b0_.id AS id_3, b0_.status AS status_4, b0_.applied_at AS applied_at_5, b0_.hired_at AS hired_at_6, b0_.document_requested_at AS document_requested_at_7, b0_.document_provided_at AS document_provided_at_8, b0_.one_file_requested_at AS one_file_requested_at_9, b0_.one_file_provided_at AS one_file_provided_at_10, b0_.contract_sent_at AS contract_sent_at_11, b0_.contract_file_name AS contract_file_name_12, b0_.contract_url AS contract_url_13, b0_.contract_signed_at AS contract_signed_at_14, b0_.contract_signed_file_name AS contract_signed_file_name_15, b0_.`rank` AS rank_16, b0_.archived_at AS archived_at_17, b0_.is_rewards_awarded AS is_rewards_awarded_18, b0_.is_archived AS is_archived_19, b0_.created_at AS created_at_20, b0_.updated_at AS updated_at_21, b0_.employer_id AS employer_id_22, b0_.staffing_agency_id AS staffing_agency_id_23, b0_.recruiter_id AS recruiter_id_24, b0_.provider_id AS provider_id_25, b0_.job_id AS job_id_26, b0_.interview_id AS interview_id_27 FROM b_application b0_ WHERE b0_.provider_id = ? AND (b0_.contract_file_name IS NOT NULL OR b0_.contract_url IS NOT NULL) AND b0_.contract_signed_at IS NULL"
  "params" => [
    1 => Symfony\Component\Uid\UuidV6 {#1172
      #uid: "1f1214c0-8b40-6d9e-80db-2ff2d72f559a"
      toBase58: "4qXmo887yVoNdsWc9uCkFj"
      toBase32: "0Z28AC12T0DPF81PSFYBBJYNCT"
      time: "2026-03-16 15:23:07.244483 UTC"
    }
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.url AS url_2, b0_.description AS description_3, b0_.sender AS sender_4, b0_.created_at AS created_at_5, b0_.is_active AS is_active_6, b0_.status AS status_7, b0_.submitted_at AS submitted_at_8, b0_.last_opened_at AS last_opened_at_9, b0_.open_count AS open_count_10, b0_.completed_at AS completed_at_11, b0_.provider_response AS provider_response_12, b0_.provider_id AS provider_id_13, b0_.job_id AS job_id_14 FROM b_credentialing_links b0_ WHERE b0_.provider_id = ? AND b0_.completed_at IS NULL"
  "params" => [
    1 => Symfony\Component\Uid\UuidV6 {#1172
      #uid: "1f1214c0-8b40-6d9e-80db-2ff2d72f559a"
      toBase58: "4qXmo887yVoNdsWc9uCkFj"
      toBase32: "0Z28AC12T0DPF81PSFYBBJYNCT"
      time: "2026-03-16 15:23:07.244483 UTC"
    }
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.email AS email_6, t0.website AS website_7, t0.logo AS logo_8, t0.average_point AS average_point_9, t0.company_name AS company_name_10, t0.contact_person_name AS contact_person_name_11, t0.contact_email AS contact_email_12, t0.notification_preferences AS notification_preferences_13, t0.auto_verify AS auto_verify_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.user_id AS user_id_17 FROM b_employer t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.end_date AS end_date_2, b0_.meeting_url AS meeting_url_3, b0_.meeting_platform AS meeting_platform_4, b0_.comment AS comment_5, b0_.status AS status_6, b0_.created_at AS created_at_7, b0_.updated_at AS updated_at_8, b0_.application_id AS application_id_9 FROM b_interview b0_ LEFT JOIN b_application b1_ ON b0_.application_id = b1_.id WHERE b1_.provider_id = ?"
  "params" => [
    1 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
  ]
  "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.amount AS amount_2, t0.particular AS particular_3, t0.status AS status_4, t0.invoice_number AS invoice_number_5, t0.payout_status AS payout_status_6, t0.payout_date AS payout_date_7, t0.payout_reference AS payout_reference_8, t0.stripe_session_id AS stripe_session_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.employer_id AS employer_id_12, t0.recruiter_id AS recruiter_id_13, t0.provider_id AS provider_id_14, t0.staffing_agency_id AS staffing_agency_id_15, t0.job_id AS job_id_16 FROM b_invoice t0 WHERE t0.provider_id = ? AND t0.status = ? ORDER BY t0.created_at DESC"
  "params" => [
    1 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
    2 => "paid"
  ]
  "types" => [
    1 => 2
    2 => 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_type = ? AND t0.seen = ? AND t0.user_id = ? ORDER BY t0.created_at DESC LIMIT 5"
  "params" => [
    1 => "PROVIDER"
    2 => 0
    3 => b"\x1F\x12\x14À‘ƒc¾„ž/ò×/Uš"
  ]
  "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.user_type = ? AND t0.seen = ?"
  "params" => [
    1 => b"\x1F\x12\x14À‘ƒc¾„ž/ò×/Uš"
    2 => "PROVIDER"
    3 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "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.stripe_customer_id AS stripe_customer_id_15, t0.stripe_connect_id AS stripe_connect_id_16, t0.stripe_account_status AS stripe_account_status_17, t0.subscription_status AS subscription_status_18, t0.subscription_ends_at AS subscription_ends_at_19, t0.custom_fee_structure AS custom_fee_structure_20, t0.phone1 AS phone1_21, t0.phone2 AS phone2_22, t0.bio AS bio_23, t0.nickname AS nickname_24, t0.blocked AS blocked_25, t0.mfa_code AS mfa_code_26, t0.mfa_expires_at AS mfa_expires_at_27, t0.is_hybrid_recruiter AS is_hybrid_recruiter_28, t0.address AS address_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.employer_id AS employer_id_32, t0.staffing_agency_id AS staffing_agency_id_33, t35.id AS id_34, t35.name AS name_36, t35.suffix AS suffix_37, t35.title AS title_38, t35.npi_number AS npi_number_39, t35.phone_home AS phone_home_40, t35.phone_work AS phone_work_41, t35.phone_mobile AS phone_mobile_42, t35.cv_filename AS cv_filename_43, t35.country AS country_44, t35.state AS state_45, t35.city AS city_46, t35.zip_code AS zip_code_47, t35.street_address AS street_address_48, t35.desired_pay_rate AS desired_pay_rate_49, t35.pay_rate_hourly AS pay_rate_hourly_50, t35.pay_rate_daily AS pay_rate_daily_51, t35.desired_hour AS desired_hour_52, t35.desired_states AS desired_states_53, t35.availability_to_start AS availability_to_start_54, t35.willing_to_travel AS willing_to_travel_55, t35.preferred_patient_volume AS preferred_patient_volume_56, t35.release_authorization_date AS release_authorization_date_57, t35.ssn AS ssn_58, t35.dob AS dob_59, t35.country_of_birth AS country_of_birth_60, t35.state_of_birth AS state_of_birth_61, t35.city_of_birth AS city_of_birth_62, t35.release_and_authorization_accepted AS release_and_authorization_accepted_63, t35.application_certification_date AS application_certification_date_64, t35.risk_assessment AS risk_assessment_65, t35.health_assessment AS health_assessment_66, t35.cashback AS cashback_67, t35.notification_preferences AS notification_preferences_68, t35.average_point AS average_point_69, t35.skip_onboarding AS skip_onboarding_70, t35.professional_references AS professional_references_71, t35.rewards_points AS rewards_points_72, t35.created_at AS created_at_73, t35.updated_at AS updated_at_74, t35.user_id AS user_id_75, t35.profession_id AS profession_id_76, t78.id AS id_77, t78.company_name AS company_name_79, t78.speciality AS speciality_80, t78.membership_level AS membership_level_81, t78.rating AS rating_82, t78.is_verified AS is_verified_83, t78.stripe_connect_account_id AS stripe_connect_account_id_84, t78.stripe_account_status AS stripe_account_status_85, t78.created_at AS created_at_86, t78.updated_at AS updated_at_87, t78.user_id AS user_id_88, t90.id AS id_89, t90.balance AS balance_91, t90.updated_at AS updated_at_92, t90.user_id AS user_id_93, t0.membership_tier_id AS membership_tier_id_94, t0.recruiter_id AS recruiter_id_95, t0.dtype FROM b_user t0 LEFT JOIN b_provider t35 ON t35.user_id = t0.id LEFT JOIN b_recruiter t78 ON t78.user_id = t0.id LEFT JOIN b_credit_wallet t90 ON t90.user_id = t0.id WHERE t0.id = ? AND t0.dtype IN ('user')"
  "params" => [
    1 => b"\x1F\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.speciality AS speciality_3, t0.membership_level AS membership_level_4, t0.rating AS rating_5, t0.is_verified AS is_verified_6, t0.stripe_connect_account_id AS stripe_connect_account_id_7, t0.stripe_account_status AS stripe_account_status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM b_recruiter t0 WHERE t0.id = ?"
  "params" => [
    1 => b"""
      \x1F\x11=\x1E\x1Eýa\x16 ¸µ\n
      Ã!ƒ¸
      """
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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.stripe_customer_id AS stripe_customer_id_15, t0.stripe_connect_id AS stripe_connect_id_16, t0.stripe_account_status AS stripe_account_status_17, t0.subscription_status AS subscription_status_18, t0.subscription_ends_at AS subscription_ends_at_19, t0.custom_fee_structure AS custom_fee_structure_20, t0.phone1 AS phone1_21, t0.phone2 AS phone2_22, t0.bio AS bio_23, t0.nickname AS nickname_24, t0.blocked AS blocked_25, t0.mfa_code AS mfa_code_26, t0.mfa_expires_at AS mfa_expires_at_27, t0.is_hybrid_recruiter AS is_hybrid_recruiter_28, t0.address AS address_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.employer_id AS employer_id_32, t0.staffing_agency_id AS staffing_agency_id_33, t35.id AS id_34, t35.name AS name_36, t35.suffix AS suffix_37, t35.title AS title_38, t35.npi_number AS npi_number_39, t35.phone_home AS phone_home_40, t35.phone_work AS phone_work_41, t35.phone_mobile AS phone_mobile_42, t35.cv_filename AS cv_filename_43, t35.country AS country_44, t35.state AS state_45, t35.city AS city_46, t35.zip_code AS zip_code_47, t35.street_address AS street_address_48, t35.desired_pay_rate AS desired_pay_rate_49, t35.pay_rate_hourly AS pay_rate_hourly_50, t35.pay_rate_daily AS pay_rate_daily_51, t35.desired_hour AS desired_hour_52, t35.desired_states AS desired_states_53, t35.availability_to_start AS availability_to_start_54, t35.willing_to_travel AS willing_to_travel_55, t35.preferred_patient_volume AS preferred_patient_volume_56, t35.release_authorization_date AS release_authorization_date_57, t35.ssn AS ssn_58, t35.dob AS dob_59, t35.country_of_birth AS country_of_birth_60, t35.state_of_birth AS state_of_birth_61, t35.city_of_birth AS city_of_birth_62, t35.release_and_authorization_accepted AS release_and_authorization_accepted_63, t35.application_certification_date AS application_certification_date_64, t35.risk_assessment AS risk_assessment_65, t35.health_assessment AS health_assessment_66, t35.cashback AS cashback_67, t35.notification_preferences AS notification_preferences_68, t35.average_point AS average_point_69, t35.skip_onboarding AS skip_onboarding_70, t35.professional_references AS professional_references_71, t35.rewards_points AS rewards_points_72, t35.created_at AS created_at_73, t35.updated_at AS updated_at_74, t35.user_id AS user_id_75, t35.profession_id AS profession_id_76, t78.id AS id_77, t78.company_name AS company_name_79, t78.speciality AS speciality_80, t78.membership_level AS membership_level_81, t78.rating AS rating_82, t78.is_verified AS is_verified_83, t78.stripe_connect_account_id AS stripe_connect_account_id_84, t78.stripe_account_status AS stripe_account_status_85, t78.created_at AS created_at_86, t78.updated_at AS updated_at_87, t78.user_id AS user_id_88, t90.id AS id_89, t90.balance AS balance_91, t90.updated_at AS updated_at_92, t90.user_id AS user_id_93, t0.membership_tier_id AS membership_tier_id_94, t0.recruiter_id AS recruiter_id_95, t0.dtype FROM b_user t0 LEFT JOIN b_provider t35 ON t35.user_id = t0.id LEFT JOIN b_recruiter t78 ON t78.user_id = t0.id LEFT JOIN b_credit_wallet t90 ON t90.user_id = t0.id WHERE t0.id = ? AND t0.dtype IN ('user')"
  "params" => [
    1 => b"""
      \x1F\x11=\x1E\x1Eýmx•¤µ\n
      Ã!ƒ¸
      """
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13žH\x7Ff&€­5¤8N8Ä"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.status_mode AS status_mode_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.status AS status_5, t0.country AS country_6, t0.state AS state_7, t0.city AS city_8, t0.street_address AS street_address_9, t0.expiration_date AS expiration_date_10, t0.highlight AS highlight_11, t0.schedule AS schedule_12, t0.start_date AS start_date_13, t0.year_of_experience AS year_of_experience_14, t0.pay_rate AS pay_rate_15, t0.work_type AS work_type_16, t0.need AS need_17, t0.pay_rate_hourly AS pay_rate_hourly_18, t0.pay_rate_daily AS pay_rate_daily_19, t0.annual_salary AS annual_salary_20, t0.monthly_salary AS monthly_salary_21, t0.salary_type AS salary_type_22, t0.blocked AS blocked_23, t0.job_id AS job_id_24, t0.verified AS verified_25, t0.is_mediated AS is_mediated_26, t0.`rank` AS rank_27, t0.archived_at AS archived_at_28, t0.is_archived AS is_archived_29, t0.agency_payout_status AS agency_payout_status_30, t0.agency_payout_amount AS agency_payout_amount_31, t0.agency_payout_date AS agency_payout_date_32, t0.agency_payout_reference AS agency_payout_reference_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.user_id AS user_id_36, t0.employer_id AS employer_id_37, t0.staffing_agency_id AS staffing_agency_id_38, t0.profession_id AS profession_id_39, t0.speciality_id AS speciality_id_40, t0.assigned_recruiter_id AS assigned_recruiter_id_41 FROM b_job t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x1F\x13│Ðð\x02`\fÅ>Ú¡\fÞ╝ã"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13zeé\x01cÒ¡ÐE›B±\x0EÑ"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13zeÚ\x01a\x16ÅÏEøB▒\x0EÐ"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13zeé\x00n<±yE›B±\x0EÑ"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13zeé\x00k0ˆáE›B±\x0EÑ"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13`‰ï5jZ‘ós\x1A­ÜQo"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13`‰ï5hŽ¢és\x1A­ÜQo"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13`‰ï5fJªÀs\x1A­ÜQo"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13`‰ï5c¶±òs\x1A­ÜQo"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13;|×xjrÅ┐ÀX\x10]ï┘"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13;|žxhΤº·X\x10]‹Ù"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13;|×xg\x16Ø£ÀX\x10]ï┘"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13;|×xeJÅ┤ÀX\x10]ï┘"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13;kƒ\x00hx°ÒÙa\x10\x1F\n³"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13;kƒ\x00oX—†Ùa\x10\x1F\n³"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13;kƒ\x00lºµ,Ùa\x10\x1F\n³"
  ]
  "types" => [
    1 => 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.id = ?"
  "params" => [
    1 => b"\x1F\x13;kâ\x00jDü¡┘a\x10\x1F\n│"
  ]
  "types" => [
    1 => 2
  ]
]

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