Symfony Profiler

[
  "route" => "app_employer_applications"
  "route_parameters" => [
    "_route" => "app_employer_applications"
    "_controller" => "App\Controller\Employer\ApplicationController::index"
  ]
  "request_uri" => "https://bill.flexzob.com/employer/applications/?status=applied"
  "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\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "testemployer1@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 b0_.status AS status_0, COUNT(b0_.id) AS sclr_1 FROM b_application b0_ WHERE b0_.employer_id = ? AND b0_.archived_at IS NULL GROUP BY b0_.status"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT count(b0_.id) AS sclr_0 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id WHERE b1_.employer_id = ? AND b0_.archived_at IS NULL"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (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, b1_.status_mode AS status_mode_22, b1_.id AS id_23, b1_.title AS title_24, b1_.description AS description_25, b1_.status AS status_26, b1_.country AS country_27, b1_.state AS state_28, b1_.city AS city_29, b1_.street_address AS street_address_30, b1_.expiration_date AS expiration_date_31, b1_.highlight AS highlight_32, b1_.schedule AS schedule_33, b1_.start_date AS start_date_34, b1_.year_of_experience AS year_of_experience_35, b1_.pay_rate AS pay_rate_36, b1_.work_type AS work_type_37, b1_.need AS need_38, b1_.pay_rate_hourly AS pay_rate_hourly_39, b1_.pay_rate_daily AS pay_rate_daily_40, b1_.annual_salary AS annual_salary_41, b1_.monthly_salary AS monthly_salary_42, b1_.salary_type AS salary_type_43, b1_.blocked AS blocked_44, b1_.job_id AS job_id_45, b1_.verified AS verified_46, b1_.is_mediated AS is_mediated_47, b1_.`rank` AS rank_48, b1_.archived_at AS archived_at_49, b1_.is_archived AS is_archived_50, b1_.agency_payout_status AS agency_payout_status_51, b1_.agency_payout_amount AS agency_payout_amount_52, b1_.agency_payout_date AS agency_payout_date_53, b1_.agency_payout_reference AS agency_payout_reference_54, b1_.created_at AS created_at_55, b1_.updated_at AS updated_at_56, b2_.id AS id_57, b2_.name AS name_58, b2_.address AS address_59, b2_.phone1 AS phone1_60, b2_.phone2 AS phone2_61, b2_.email AS email_62, b2_.website AS website_63, b2_.logo AS logo_64, b2_.average_point AS average_point_65, b2_.company_name AS company_name_66, b2_.contact_person_name AS contact_person_name_67, b2_.contact_email AS contact_email_68, b2_.notification_preferences AS notification_preferences_69, b2_.auto_verify AS auto_verify_70, b2_.created_at AS created_at_71, b2_.updated_at AS updated_at_72, b3_.id AS id_73, b3_.name AS name_74, b3_.address AS address_75, b3_.phone1 AS phone1_76, b3_.phone2 AS phone2_77, b3_.email AS email_78, b3_.website AS website_79, b3_.logo AS logo_80, b3_.average_point AS average_point_81, b3_.company_name AS company_name_82, b3_.contact_person_name AS contact_person_name_83, b3_.contact_email AS contact_email_84, b3_.notification_preferences AS notification_preferences_85, b3_.auto_verify AS auto_verify_86, b3_.created_at AS created_at_87, b3_.updated_at AS updated_at_88, b4_.id AS id_89, b4_.name AS name_90, b4_.address AS address_91, b4_.phone1 AS phone1_92, b4_.phone2 AS phone2_93, b4_.email AS email_94, b4_.website AS website_95, b4_.logo AS logo_96, b4_.average_point AS average_point_97, b4_.company_name AS company_name_98, b4_.contact_person_name AS contact_person_name_99, b4_.contact_email AS contact_email_100, b4_.notification_preferences AS notification_preferences_101, b4_.auto_verify AS auto_verify_102, b4_.created_at AS created_at_103, b4_.updated_at AS updated_at_104, b5_.id AS id_105, b5_.name AS name_106, b5_.address AS address_107, b5_.phone1 AS phone1_108, b5_.phone2 AS phone2_109, b5_.email AS email_110, b5_.website AS website_111, b5_.logo AS logo_112, b5_.average_point AS average_point_113, b5_.company_name AS company_name_114, b5_.contact_person_name AS contact_person_name_115, b5_.contact_email AS contact_email_116, b5_.notification_preferences AS notification_preferences_117, b5_.auto_verify AS auto_verify_118, b5_.created_at AS created_at_119, b5_.updated_at AS updated_at_120, b6_.id AS id_121, b6_.company_name AS company_name_122, b6_.speciality AS speciality_123, b6_.membership_level AS membership_level_124, b6_.rating AS rating_125, b6_.is_verified AS is_verified_126, b6_.stripe_connect_account_id AS stripe_connect_account_id_127, b6_.stripe_account_status AS stripe_account_status_128, b6_.created_at AS created_at_129, b6_.updated_at AS updated_at_130, b7_.id AS id_131, b7_.company_name AS company_name_132, b7_.speciality AS speciality_133, b7_.membership_level AS membership_level_134, b7_.rating AS rating_135, b7_.is_verified AS is_verified_136, b7_.stripe_connect_account_id AS stripe_connect_account_id_137, b7_.stripe_account_status AS stripe_account_status_138, b7_.created_at AS created_at_139, b7_.updated_at AS updated_at_140, b8_.id AS id_141, b8_.name AS name_142, b8_.suffix AS suffix_143, b8_.title AS title_144, b8_.npi_number AS npi_number_145, b8_.phone_home AS phone_home_146, b8_.phone_work AS phone_work_147, b8_.phone_mobile AS phone_mobile_148, b8_.cv_filename AS cv_filename_149, b8_.country AS country_150, b8_.state AS state_151, b8_.city AS city_152, b8_.zip_code AS zip_code_153, b8_.street_address AS street_address_154, b8_.desired_pay_rate AS desired_pay_rate_155, b8_.pay_rate_hourly AS pay_rate_hourly_156, b8_.pay_rate_daily AS pay_rate_daily_157, b8_.desired_hour AS desired_hour_158, b8_.desired_states AS desired_states_159, b8_.availability_to_start AS availability_to_start_160, b8_.willing_to_travel AS willing_to_travel_161, b8_.preferred_patient_volume AS preferred_patient_volume_162, b8_.release_authorization_date AS release_authorization_date_163, b8_.ssn AS ssn_164, b8_.dob AS dob_165, b8_.country_of_birth AS country_of_birth_166, b8_.state_of_birth AS state_of_birth_167, b8_.city_of_birth AS city_of_birth_168, b8_.release_and_authorization_accepted AS release_and_authorization_accepted_169, b8_.application_certification_date AS application_certification_date_170, b8_.risk_assessment AS risk_assessment_171, b8_.health_assessment AS health_assessment_172, b8_.cashback AS cashback_173, b8_.notification_preferences AS notification_preferences_174, b8_.average_point AS average_point_175, b8_.skip_onboarding AS skip_onboarding_176, b8_.rewards_points AS rewards_points_177, b8_.created_at AS created_at_178, b8_.updated_at AS updated_at_179, b9_.id AS id_180, b9_.name AS name_181, b9_.email AS email_182, b9_.user_type AS user_type_183, b9_.roles AS roles_184, b9_.password AS password_185, b9_.is_verified AS is_verified_186, b9_.oauth_provider AS oauth_provider_187, b9_.oauth_id AS oauth_id_188, b9_.profile_picture_filename AS profile_picture_filename_189, b9_.oauth_data AS oauth_data_190, b9_.on_boarding_completed_at AS on_boarding_completed_at_191, b9_.dob AS dob_192, b9_.gender AS gender_193, b9_.stripe_customer_id AS stripe_customer_id_194, b9_.stripe_connect_id AS stripe_connect_id_195, b9_.stripe_account_status AS stripe_account_status_196, b9_.subscription_status AS subscription_status_197, b9_.subscription_ends_at AS subscription_ends_at_198, b9_.custom_fee_structure AS custom_fee_structure_199, b9_.phone1 AS phone1_200, b9_.phone2 AS phone2_201, b9_.bio AS bio_202, b9_.nickname AS nickname_203, b9_.blocked AS blocked_204, b9_.mfa_code AS mfa_code_205, b9_.mfa_expires_at AS mfa_expires_at_206, b9_.is_hybrid_recruiter AS is_hybrid_recruiter_207, b9_.address AS address_208, b9_.created_at AS created_at_209, b9_.updated_at AS updated_at_210, b10_.id AS id_211, b10_.name AS name_212, b10_.email AS email_213, b10_.user_type AS user_type_214, b10_.roles AS roles_215, b10_.password AS password_216, b10_.is_verified AS is_verified_217, b10_.oauth_provider AS oauth_provider_218, b10_.oauth_id AS oauth_id_219, b10_.profile_picture_filename AS profile_picture_filename_220, b10_.oauth_data AS oauth_data_221, b10_.on_boarding_completed_at AS on_boarding_completed_at_222, b10_.dob AS dob_223, b10_.gender AS gender_224, b10_.stripe_customer_id AS stripe_customer_id_225, b10_.stripe_connect_id AS stripe_connect_id_226, b10_.stripe_account_status AS stripe_account_status_227, b10_.subscription_status AS subscription_status_228, b10_.subscription_ends_at AS subscription_ends_at_229, b10_.custom_fee_structure AS custom_fee_structure_230, b10_.phone1 AS phone1_231, b10_.phone2 AS phone2_232, b10_.bio AS bio_233, b10_.nickname AS nickname_234, b10_.blocked AS blocked_235, b10_.mfa_code AS mfa_code_236, b10_.mfa_expires_at AS mfa_expires_at_237, b10_.is_hybrid_recruiter AS is_hybrid_recruiter_238, b10_.address AS address_239, b10_.created_at AS created_at_240, b10_.updated_at AS updated_at_241, b11_.id AS id_242, b11_.name AS name_243, b11_.address AS address_244, b11_.phone1 AS phone1_245, b11_.phone2 AS phone2_246, b11_.email AS email_247, b11_.website AS website_248, b11_.logo AS logo_249, b11_.average_point AS average_point_250, b11_.company_name AS company_name_251, b11_.contact_person_name AS contact_person_name_252, b11_.contact_email AS contact_email_253, b11_.notification_preferences AS notification_preferences_254, b11_.auto_verify AS auto_verify_255, b11_.created_at AS created_at_256, b11_.updated_at AS updated_at_257, b12_.id AS id_258, b12_.name AS name_259, b12_.address AS address_260, b12_.phone1 AS phone1_261, b12_.phone2 AS phone2_262, b12_.email AS email_263, b12_.website AS website_264, b12_.logo AS logo_265, b12_.average_point AS average_point_266, b12_.company_name AS company_name_267, b12_.contact_person_name AS contact_person_name_268, b12_.contact_email AS contact_email_269, b12_.notification_preferences AS notification_preferences_270, b12_.auto_verify AS auto_verify_271, b12_.created_at AS created_at_272, b12_.updated_at AS updated_at_273, b13_.id AS id_274, b13_.company_name AS company_name_275, b13_.speciality AS speciality_276, b13_.membership_level AS membership_level_277, b13_.rating AS rating_278, b13_.is_verified AS is_verified_279, b13_.stripe_connect_account_id AS stripe_connect_account_id_280, b13_.stripe_account_status AS stripe_account_status_281, b13_.created_at AS created_at_282, b13_.updated_at AS updated_at_283, b14_.id AS id_284, b14_.name AS name_285, b14_.email AS email_286, b14_.user_type AS user_type_287, b14_.roles AS roles_288, b14_.password AS password_289, b14_.is_verified AS is_verified_290, b14_.oauth_provider AS oauth_provider_291, b14_.oauth_id AS oauth_id_292, b14_.profile_picture_filename AS profile_picture_filename_293, b14_.oauth_data AS oauth_data_294, b14_.on_boarding_completed_at AS on_boarding_completed_at_295, b14_.dob AS dob_296, b14_.gender AS gender_297, b14_.stripe_customer_id AS stripe_customer_id_298, b14_.stripe_connect_id AS stripe_connect_id_299, b14_.stripe_account_status AS stripe_account_status_300, b14_.subscription_status AS subscription_status_301, b14_.subscription_ends_at AS subscription_ends_at_302, b14_.custom_fee_structure AS custom_fee_structure_303, b14_.phone1 AS phone1_304, b14_.phone2 AS phone2_305, b14_.bio AS bio_306, b14_.nickname AS nickname_307, b14_.blocked AS blocked_308, b14_.mfa_code AS mfa_code_309, b14_.mfa_expires_at AS mfa_expires_at_310, b14_.is_hybrid_recruiter AS is_hybrid_recruiter_311, b14_.address AS address_312, b14_.created_at AS created_at_313, b14_.updated_at AS updated_at_314, b9_.dtype AS dtype_315, b10_.dtype AS dtype_316, b14_.dtype AS dtype_317 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id LEFT JOIN b_employer b2_ ON b0_.employer_id = b2_.id LEFT JOIN b_staffing_agency b3_ ON b0_.staffing_agency_id = b3_.id LEFT JOIN b_employer b4_ ON b1_.employer_id = b4_.id LEFT JOIN b_staffing_agency b5_ ON b1_.staffing_agency_id = b5_.id LEFT JOIN b_recruiter b6_ ON b0_.recruiter_id = b6_.id LEFT JOIN b_recruiter b7_ ON b1_.assigned_recruiter_id = b7_.id LEFT JOIN b_job_recruiter b15_ ON b1_.id = b15_.job_id LEFT JOIN b_provider b8_ ON b0_.provider_id = b8_.id LEFT JOIN b_user b9_ ON b8_.user_id = b9_.id AND b9_.dtype IN ('user') LEFT JOIN b_user b10_ ON b1_.user_id = b10_.id AND b10_.dtype IN ('user') LEFT JOIN b_employer b11_ ON b10_.employer_id = b11_.id LEFT JOIN b_staffing_agency b12_ ON b10_.staffing_agency_id = b12_.id LEFT JOIN b_recruiter b13_ ON b10_.id = b13_.user_id LEFT JOIN b_user b14_ ON b7_.user_id = b14_.id AND b14_.dtype IN ('user') WHERE 1 = 1 AND b0_.archived_at IS NULL AND b0_.status IN (?) AND b0_.employer_id = ? ORDER BY b0_.id DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => "applied"
    2 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3 FROM (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, b1_.status_mode AS status_mode_22, b1_.id AS id_23, b1_.title AS title_24, b1_.description AS description_25, b1_.status AS status_26, b1_.country AS country_27, b1_.state AS state_28, b1_.city AS city_29, b1_.street_address AS street_address_30, b1_.expiration_date AS expiration_date_31, b1_.highlight AS highlight_32, b1_.schedule AS schedule_33, b1_.start_date AS start_date_34, b1_.year_of_experience AS year_of_experience_35, b1_.pay_rate AS pay_rate_36, b1_.work_type AS work_type_37, b1_.need AS need_38, b1_.pay_rate_hourly AS pay_rate_hourly_39, b1_.pay_rate_daily AS pay_rate_daily_40, b1_.annual_salary AS annual_salary_41, b1_.monthly_salary AS monthly_salary_42, b1_.salary_type AS salary_type_43, b1_.blocked AS blocked_44, b1_.job_id AS job_id_45, b1_.verified AS verified_46, b1_.is_mediated AS is_mediated_47, b1_.`rank` AS rank_48, b1_.archived_at AS archived_at_49, b1_.is_archived AS is_archived_50, b1_.agency_payout_status AS agency_payout_status_51, b1_.agency_payout_amount AS agency_payout_amount_52, b1_.agency_payout_date AS agency_payout_date_53, b1_.agency_payout_reference AS agency_payout_reference_54, b1_.created_at AS created_at_55, b1_.updated_at AS updated_at_56, b2_.id AS id_57, b2_.name AS name_58, b2_.address AS address_59, b2_.phone1 AS phone1_60, b2_.phone2 AS phone2_61, b2_.email AS email_62, b2_.website AS website_63, b2_.logo AS logo_64, b2_.average_point AS average_point_65, b2_.company_name AS company_name_66, b2_.contact_person_name AS contact_person_name_67, b2_.contact_email AS contact_email_68, b2_.notification_preferences AS notification_preferences_69, b2_.auto_verify AS auto_verify_70, b2_.created_at AS created_at_71, b2_.updated_at AS updated_at_72, b3_.id AS id_73, b3_.name AS name_74, b3_.address AS address_75, b3_.phone1 AS phone1_76, b3_.phone2 AS phone2_77, b3_.email AS email_78, b3_.website AS website_79, b3_.logo AS logo_80, b3_.average_point AS average_point_81, b3_.company_name AS company_name_82, b3_.contact_person_name AS contact_person_name_83, b3_.contact_email AS contact_email_84, b3_.notification_preferences AS notification_preferences_85, b3_.auto_verify AS auto_verify_86, b3_.created_at AS created_at_87, b3_.updated_at AS updated_at_88, b4_.id AS id_89, b4_.name AS name_90, b4_.address AS address_91, b4_.phone1 AS phone1_92, b4_.phone2 AS phone2_93, b4_.email AS email_94, b4_.website AS website_95, b4_.logo AS logo_96, b4_.average_point AS average_point_97, b4_.company_name AS company_name_98, b4_.contact_person_name AS contact_person_name_99, b4_.contact_email AS contact_email_100, b4_.notification_preferences AS notification_preferences_101, b4_.auto_verify AS auto_verify_102, b4_.created_at AS created_at_103, b4_.updated_at AS updated_at_104, b5_.id AS id_105, b5_.name AS name_106, b5_.address AS address_107, b5_.phone1 AS phone1_108, b5_.phone2 AS phone2_109, b5_.email AS email_110, b5_.website AS website_111, b5_.logo AS logo_112, b5_.average_point AS average_point_113, b5_.company_name AS company_name_114, b5_.contact_person_name AS contact_person_name_115, b5_.contact_email AS contact_email_116, b5_.notification_preferences AS notification_preferences_117, b5_.auto_verify AS auto_verify_118, b5_.created_at AS created_at_119, b5_.updated_at AS updated_at_120, b6_.id AS id_121, b6_.company_name AS company_name_122, b6_.speciality AS speciality_123, b6_.membership_level AS membership_level_124, b6_.rating AS rating_125, b6_.is_verified AS is_verified_126, b6_.stripe_connect_account_id AS stripe_connect_account_id_127, b6_.stripe_account_status AS stripe_account_status_128, b6_.created_at AS created_at_129, b6_.updated_at AS updated_at_130, b7_.id AS id_131, b7_.company_name AS company_name_132, b7_.speciality AS speciality_133, b7_.membership_level AS membership_level_134, b7_.rating AS rating_135, b7_.is_verified AS is_verified_136, b7_.stripe_connect_account_id AS stripe_connect_account_id_137, b7_.stripe_account_status AS stripe_account_status_138, b7_.created_at AS created_at_139, b7_.updated_at AS updated_at_140, b8_.id AS id_141, b8_.name AS name_142, b8_.suffix AS suffix_143, b8_.title AS title_144, b8_.npi_number AS npi_number_145, b8_.phone_home AS phone_home_146, b8_.phone_work AS phone_work_147, b8_.phone_mobile AS phone_mobile_148, b8_.cv_filename AS cv_filename_149, b8_.country AS country_150, b8_.state AS state_151, b8_.city AS city_152, b8_.zip_code AS zip_code_153, b8_.street_address AS street_address_154, b8_.desired_pay_rate AS desired_pay_rate_155, b8_.pay_rate_hourly AS pay_rate_hourly_156, b8_.pay_rate_daily AS pay_rate_daily_157, b8_.desired_hour AS desired_hour_158, b8_.desired_states AS desired_states_159, b8_.availability_to_start AS availability_to_start_160, b8_.willing_to_travel AS willing_to_travel_161, b8_.preferred_patient_volume AS preferred_patient_volume_162, b8_.release_authorization_date AS release_authorization_date_163, b8_.ssn AS ssn_164, b8_.dob AS dob_165, b8_.country_of_birth AS country_of_birth_166, b8_.state_of_birth AS state_of_birth_167, b8_.city_of_birth AS city_of_birth_168, b8_.release_and_authorization_accepted AS release_and_authorization_accepted_169, b8_.application_certification_date AS application_certification_date_170, b8_.risk_assessment AS risk_assessment_171, b8_.health_assessment AS health_assessment_172, b8_.cashback AS cashback_173, b8_.notification_preferences AS notification_preferences_174, b8_.average_point AS average_point_175, b8_.skip_onboarding AS skip_onboarding_176, b8_.rewards_points AS rewards_points_177, b8_.created_at AS created_at_178, b8_.updated_at AS updated_at_179, b9_.id AS id_180, b9_.name AS name_181, b9_.email AS email_182, b9_.user_type AS user_type_183, b9_.roles AS roles_184, b9_.password AS password_185, b9_.is_verified AS is_verified_186, b9_.oauth_provider AS oauth_provider_187, b9_.oauth_id AS oauth_id_188, b9_.profile_picture_filename AS profile_picture_filename_189, b9_.oauth_data AS oauth_data_190, b9_.on_boarding_completed_at AS on_boarding_completed_at_191, b9_.dob AS dob_192, b9_.gender AS gender_193, b9_.stripe_customer_id AS stripe_customer_id_194, b9_.stripe_connect_id AS stripe_connect_id_195, b9_.stripe_account_status AS stripe_account_status_196, b9_.subscription_status AS subscription_status_197, b9_.subscription_ends_at AS subscription_ends_at_198, b9_.custom_fee_structure AS custom_fee_structure_199, b9_.phone1 AS phone1_200, b9_.phone2 AS phone2_201, b9_.bio AS bio_202, b9_.nickname AS nickname_203, b9_.blocked AS blocked_204, b9_.mfa_code AS mfa_code_205, b9_.mfa_expires_at AS mfa_expires_at_206, b9_.is_hybrid_recruiter AS is_hybrid_recruiter_207, b9_.address AS address_208, b9_.created_at AS created_at_209, b9_.updated_at AS updated_at_210, b10_.id AS id_211, b10_.name AS name_212, b10_.email AS email_213, b10_.user_type AS user_type_214, b10_.roles AS roles_215, b10_.password AS password_216, b10_.is_verified AS is_verified_217, b10_.oauth_provider AS oauth_provider_218, b10_.oauth_id AS oauth_id_219, b10_.profile_picture_filename AS profile_picture_filename_220, b10_.oauth_data AS oauth_data_221, b10_.on_boarding_completed_at AS on_boarding_completed_at_222, b10_.dob AS dob_223, b10_.gender AS gender_224, b10_.stripe_customer_id AS stripe_customer_id_225, b10_.stripe_connect_id AS stripe_connect_id_226, b10_.stripe_account_status AS stripe_account_status_227, b10_.subscription_status AS subscription_status_228, b10_.subscription_ends_at AS subscription_ends_at_229, b10_.custom_fee_structure AS custom_fee_structure_230, b10_.phone1 AS phone1_231, b10_.phone2 AS phone2_232, b10_.bio AS bio_233, b10_.nickname AS nickname_234, b10_.blocked AS blocked_235, b10_.mfa_code AS mfa_code_236, b10_.mfa_expires_at AS mfa_expires_at_237, b10_.is_hybrid_recruiter AS is_hybrid_recruiter_238, b10_.address AS address_239, b10_.created_at AS created_at_240, b10_.updated_at AS updated_at_241, b11_.id AS id_242, b11_.name AS name_243, b11_.address AS address_244, b11_.phone1 AS phone1_245, b11_.phone2 AS phone2_246, b11_.email AS email_247, b11_.website AS website_248, b11_.logo AS logo_249, b11_.average_point AS average_point_250, b11_.company_name AS company_name_251, b11_.contact_person_name AS contact_person_name_252, b11_.contact_email AS contact_email_253, b11_.notification_preferences AS notification_preferences_254, b11_.auto_verify AS auto_verify_255, b11_.created_at AS created_at_256, b11_.updated_at AS updated_at_257, b12_.id AS id_258, b12_.name AS name_259, b12_.address AS address_260, b12_.phone1 AS phone1_261, b12_.phone2 AS phone2_262, b12_.email AS email_263, b12_.website AS website_264, b12_.logo AS logo_265, b12_.average_point AS average_point_266, b12_.company_name AS company_name_267, b12_.contact_person_name AS contact_person_name_268, b12_.contact_email AS contact_email_269, b12_.notification_preferences AS notification_preferences_270, b12_.auto_verify AS auto_verify_271, b12_.created_at AS created_at_272, b12_.updated_at AS updated_at_273, b13_.id AS id_274, b13_.company_name AS company_name_275, b13_.speciality AS speciality_276, b13_.membership_level AS membership_level_277, b13_.rating AS rating_278, b13_.is_verified AS is_verified_279, b13_.stripe_connect_account_id AS stripe_connect_account_id_280, b13_.stripe_account_status AS stripe_account_status_281, b13_.created_at AS created_at_282, b13_.updated_at AS updated_at_283, b14_.id AS id_284, b14_.name AS name_285, b14_.email AS email_286, b14_.user_type AS user_type_287, b14_.roles AS roles_288, b14_.password AS password_289, b14_.is_verified AS is_verified_290, b14_.oauth_provider AS oauth_provider_291, b14_.oauth_id AS oauth_id_292, b14_.profile_picture_filename AS profile_picture_filename_293, b14_.oauth_data AS oauth_data_294, b14_.on_boarding_completed_at AS on_boarding_completed_at_295, b14_.dob AS dob_296, b14_.gender AS gender_297, b14_.stripe_customer_id AS stripe_customer_id_298, b14_.stripe_connect_id AS stripe_connect_id_299, b14_.stripe_account_status AS stripe_account_status_300, b14_.subscription_status AS subscription_status_301, b14_.subscription_ends_at AS subscription_ends_at_302, b14_.custom_fee_structure AS custom_fee_structure_303, b14_.phone1 AS phone1_304, b14_.phone2 AS phone2_305, b14_.bio AS bio_306, b14_.nickname AS nickname_307, b14_.blocked AS blocked_308, b14_.mfa_code AS mfa_code_309, b14_.mfa_expires_at AS mfa_expires_at_310, b14_.is_hybrid_recruiter AS is_hybrid_recruiter_311, b14_.address AS address_312, b14_.created_at AS created_at_313, b14_.updated_at AS updated_at_314, b9_.dtype AS dtype_315, b10_.dtype AS dtype_316, b14_.dtype AS dtype_317 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id LEFT JOIN b_employer b2_ ON b0_.employer_id = b2_.id LEFT JOIN b_staffing_agency b3_ ON b0_.staffing_agency_id = b3_.id LEFT JOIN b_employer b4_ ON b1_.employer_id = b4_.id LEFT JOIN b_staffing_agency b5_ ON b1_.staffing_agency_id = b5_.id LEFT JOIN b_recruiter b6_ ON b0_.recruiter_id = b6_.id LEFT JOIN b_recruiter b7_ ON b1_.assigned_recruiter_id = b7_.id LEFT JOIN b_job_recruiter b15_ ON b1_.id = b15_.job_id LEFT JOIN b_provider b8_ ON b0_.provider_id = b8_.id LEFT JOIN b_user b9_ ON b8_.user_id = b9_.id AND b9_.dtype IN ('user') LEFT JOIN b_user b10_ ON b1_.user_id = b10_.id AND b10_.dtype IN ('user') LEFT JOIN b_employer b11_ ON b10_.employer_id = b11_.id LEFT JOIN b_staffing_agency b12_ ON b10_.staffing_agency_id = b12_.id LEFT JOIN b_recruiter b13_ ON b10_.id = b13_.user_id LEFT JOIN b_user b14_ ON b7_.user_id = b14_.id AND b14_.dtype IN ('user') WHERE 1 = 1 AND b0_.archived_at IS NULL AND b0_.status IN (?) AND b0_.employer_id = ?) dctrn_result_inner ORDER BY id_3 DESC) dctrn_result LIMIT 25"
  "params" => [
    1 => "applied"
    2 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
  ]
  "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, b1_.status_mode AS status_mode_22, b1_.id AS id_23, b1_.title AS title_24, b1_.description AS description_25, b1_.status AS status_26, b1_.country AS country_27, b1_.state AS state_28, b1_.city AS city_29, b1_.street_address AS street_address_30, b1_.expiration_date AS expiration_date_31, b1_.highlight AS highlight_32, b1_.schedule AS schedule_33, b1_.start_date AS start_date_34, b1_.year_of_experience AS year_of_experience_35, b1_.pay_rate AS pay_rate_36, b1_.work_type AS work_type_37, b1_.need AS need_38, b1_.pay_rate_hourly AS pay_rate_hourly_39, b1_.pay_rate_daily AS pay_rate_daily_40, b1_.annual_salary AS annual_salary_41, b1_.monthly_salary AS monthly_salary_42, b1_.salary_type AS salary_type_43, b1_.blocked AS blocked_44, b1_.job_id AS job_id_45, b1_.verified AS verified_46, b1_.is_mediated AS is_mediated_47, b1_.`rank` AS rank_48, b1_.archived_at AS archived_at_49, b1_.is_archived AS is_archived_50, b1_.agency_payout_status AS agency_payout_status_51, b1_.agency_payout_amount AS agency_payout_amount_52, b1_.agency_payout_date AS agency_payout_date_53, b1_.agency_payout_reference AS agency_payout_reference_54, b1_.created_at AS created_at_55, b1_.updated_at AS updated_at_56, b2_.id AS id_57, b2_.name AS name_58, b2_.address AS address_59, b2_.phone1 AS phone1_60, b2_.phone2 AS phone2_61, b2_.email AS email_62, b2_.website AS website_63, b2_.logo AS logo_64, b2_.average_point AS average_point_65, b2_.company_name AS company_name_66, b2_.contact_person_name AS contact_person_name_67, b2_.contact_email AS contact_email_68, b2_.notification_preferences AS notification_preferences_69, b2_.auto_verify AS auto_verify_70, b2_.created_at AS created_at_71, b2_.updated_at AS updated_at_72, b3_.id AS id_73, b3_.name AS name_74, b3_.address AS address_75, b3_.phone1 AS phone1_76, b3_.phone2 AS phone2_77, b3_.email AS email_78, b3_.website AS website_79, b3_.logo AS logo_80, b3_.average_point AS average_point_81, b3_.company_name AS company_name_82, b3_.contact_person_name AS contact_person_name_83, b3_.contact_email AS contact_email_84, b3_.notification_preferences AS notification_preferences_85, b3_.auto_verify AS auto_verify_86, b3_.created_at AS created_at_87, b3_.updated_at AS updated_at_88, b4_.id AS id_89, b4_.name AS name_90, b4_.address AS address_91, b4_.phone1 AS phone1_92, b4_.phone2 AS phone2_93, b4_.email AS email_94, b4_.website AS website_95, b4_.logo AS logo_96, b4_.average_point AS average_point_97, b4_.company_name AS company_name_98, b4_.contact_person_name AS contact_person_name_99, b4_.contact_email AS contact_email_100, b4_.notification_preferences AS notification_preferences_101, b4_.auto_verify AS auto_verify_102, b4_.created_at AS created_at_103, b4_.updated_at AS updated_at_104, b5_.id AS id_105, b5_.name AS name_106, b5_.address AS address_107, b5_.phone1 AS phone1_108, b5_.phone2 AS phone2_109, b5_.email AS email_110, b5_.website AS website_111, b5_.logo AS logo_112, b5_.average_point AS average_point_113, b5_.company_name AS company_name_114, b5_.contact_person_name AS contact_person_name_115, b5_.contact_email AS contact_email_116, b5_.notification_preferences AS notification_preferences_117, b5_.auto_verify AS auto_verify_118, b5_.created_at AS created_at_119, b5_.updated_at AS updated_at_120, b6_.id AS id_121, b6_.company_name AS company_name_122, b6_.speciality AS speciality_123, b6_.membership_level AS membership_level_124, b6_.rating AS rating_125, b6_.is_verified AS is_verified_126, b6_.stripe_connect_account_id AS stripe_connect_account_id_127, b6_.stripe_account_status AS stripe_account_status_128, b6_.created_at AS created_at_129, b6_.updated_at AS updated_at_130, b7_.id AS id_131, b7_.company_name AS company_name_132, b7_.speciality AS speciality_133, b7_.membership_level AS membership_level_134, b7_.rating AS rating_135, b7_.is_verified AS is_verified_136, b7_.stripe_connect_account_id AS stripe_connect_account_id_137, b7_.stripe_account_status AS stripe_account_status_138, b7_.created_at AS created_at_139, b7_.updated_at AS updated_at_140, b8_.id AS id_141, b8_.name AS name_142, b8_.suffix AS suffix_143, b8_.title AS title_144, b8_.npi_number AS npi_number_145, b8_.phone_home AS phone_home_146, b8_.phone_work AS phone_work_147, b8_.phone_mobile AS phone_mobile_148, b8_.cv_filename AS cv_filename_149, b8_.country AS country_150, b8_.state AS state_151, b8_.city AS city_152, b8_.zip_code AS zip_code_153, b8_.street_address AS street_address_154, b8_.desired_pay_rate AS desired_pay_rate_155, b8_.pay_rate_hourly AS pay_rate_hourly_156, b8_.pay_rate_daily AS pay_rate_daily_157, b8_.desired_hour AS desired_hour_158, b8_.desired_states AS desired_states_159, b8_.availability_to_start AS availability_to_start_160, b8_.willing_to_travel AS willing_to_travel_161, b8_.preferred_patient_volume AS preferred_patient_volume_162, b8_.release_authorization_date AS release_authorization_date_163, b8_.ssn AS ssn_164, b8_.dob AS dob_165, b8_.country_of_birth AS country_of_birth_166, b8_.state_of_birth AS state_of_birth_167, b8_.city_of_birth AS city_of_birth_168, b8_.release_and_authorization_accepted AS release_and_authorization_accepted_169, b8_.application_certification_date AS application_certification_date_170, b8_.risk_assessment AS risk_assessment_171, b8_.health_assessment AS health_assessment_172, b8_.cashback AS cashback_173, b8_.notification_preferences AS notification_preferences_174, b8_.average_point AS average_point_175, b8_.skip_onboarding AS skip_onboarding_176, b8_.rewards_points AS rewards_points_177, b8_.created_at AS created_at_178, b8_.updated_at AS updated_at_179, b9_.id AS id_180, b9_.name AS name_181, b9_.email AS email_182, b9_.user_type AS user_type_183, b9_.roles AS roles_184, b9_.password AS password_185, b9_.is_verified AS is_verified_186, b9_.oauth_provider AS oauth_provider_187, b9_.oauth_id AS oauth_id_188, b9_.profile_picture_filename AS profile_picture_filename_189, b9_.oauth_data AS oauth_data_190, b9_.on_boarding_completed_at AS on_boarding_completed_at_191, b9_.dob AS dob_192, b9_.gender AS gender_193, b9_.stripe_customer_id AS stripe_customer_id_194, b9_.stripe_connect_id AS stripe_connect_id_195, b9_.stripe_account_status AS stripe_account_status_196, b9_.subscription_status AS subscription_status_197, b9_.subscription_ends_at AS subscription_ends_at_198, b9_.custom_fee_structure AS custom_fee_structure_199, b9_.phone1 AS phone1_200, b9_.phone2 AS phone2_201, b9_.bio AS bio_202, b9_.nickname AS nickname_203, b9_.blocked AS blocked_204, b9_.mfa_code AS mfa_code_205, b9_.mfa_expires_at AS mfa_expires_at_206, b9_.is_hybrid_recruiter AS is_hybrid_recruiter_207, b9_.address AS address_208, b9_.created_at AS created_at_209, b9_.updated_at AS updated_at_210, b10_.id AS id_211, b10_.name AS name_212, b10_.email AS email_213, b10_.user_type AS user_type_214, b10_.roles AS roles_215, b10_.password AS password_216, b10_.is_verified AS is_verified_217, b10_.oauth_provider AS oauth_provider_218, b10_.oauth_id AS oauth_id_219, b10_.profile_picture_filename AS profile_picture_filename_220, b10_.oauth_data AS oauth_data_221, b10_.on_boarding_completed_at AS on_boarding_completed_at_222, b10_.dob AS dob_223, b10_.gender AS gender_224, b10_.stripe_customer_id AS stripe_customer_id_225, b10_.stripe_connect_id AS stripe_connect_id_226, b10_.stripe_account_status AS stripe_account_status_227, b10_.subscription_status AS subscription_status_228, b10_.subscription_ends_at AS subscription_ends_at_229, b10_.custom_fee_structure AS custom_fee_structure_230, b10_.phone1 AS phone1_231, b10_.phone2 AS phone2_232, b10_.bio AS bio_233, b10_.nickname AS nickname_234, b10_.blocked AS blocked_235, b10_.mfa_code AS mfa_code_236, b10_.mfa_expires_at AS mfa_expires_at_237, b10_.is_hybrid_recruiter AS is_hybrid_recruiter_238, b10_.address AS address_239, b10_.created_at AS created_at_240, b10_.updated_at AS updated_at_241, b11_.id AS id_242, b11_.name AS name_243, b11_.address AS address_244, b11_.phone1 AS phone1_245, b11_.phone2 AS phone2_246, b11_.email AS email_247, b11_.website AS website_248, b11_.logo AS logo_249, b11_.average_point AS average_point_250, b11_.company_name AS company_name_251, b11_.contact_person_name AS contact_person_name_252, b11_.contact_email AS contact_email_253, b11_.notification_preferences AS notification_preferences_254, b11_.auto_verify AS auto_verify_255, b11_.created_at AS created_at_256, b11_.updated_at AS updated_at_257, b12_.id AS id_258, b12_.name AS name_259, b12_.address AS address_260, b12_.phone1 AS phone1_261, b12_.phone2 AS phone2_262, b12_.email AS email_263, b12_.website AS website_264, b12_.logo AS logo_265, b12_.average_point AS average_point_266, b12_.company_name AS company_name_267, b12_.contact_person_name AS contact_person_name_268, b12_.contact_email AS contact_email_269, b12_.notification_preferences AS notification_preferences_270, b12_.auto_verify AS auto_verify_271, b12_.created_at AS created_at_272, b12_.updated_at AS updated_at_273, b13_.id AS id_274, b13_.company_name AS company_name_275, b13_.speciality AS speciality_276, b13_.membership_level AS membership_level_277, b13_.rating AS rating_278, b13_.is_verified AS is_verified_279, b13_.stripe_connect_account_id AS stripe_connect_account_id_280, b13_.stripe_account_status AS stripe_account_status_281, b13_.created_at AS created_at_282, b13_.updated_at AS updated_at_283, b14_.id AS id_284, b14_.name AS name_285, b14_.email AS email_286, b14_.user_type AS user_type_287, b14_.roles AS roles_288, b14_.password AS password_289, b14_.is_verified AS is_verified_290, b14_.oauth_provider AS oauth_provider_291, b14_.oauth_id AS oauth_id_292, b14_.profile_picture_filename AS profile_picture_filename_293, b14_.oauth_data AS oauth_data_294, b14_.on_boarding_completed_at AS on_boarding_completed_at_295, b14_.dob AS dob_296, b14_.gender AS gender_297, b14_.stripe_customer_id AS stripe_customer_id_298, b14_.stripe_connect_id AS stripe_connect_id_299, b14_.stripe_account_status AS stripe_account_status_300, b14_.subscription_status AS subscription_status_301, b14_.subscription_ends_at AS subscription_ends_at_302, b14_.custom_fee_structure AS custom_fee_structure_303, b14_.phone1 AS phone1_304, b14_.phone2 AS phone2_305, b14_.bio AS bio_306, b14_.nickname AS nickname_307, b14_.blocked AS blocked_308, b14_.mfa_code AS mfa_code_309, b14_.mfa_expires_at AS mfa_expires_at_310, b14_.is_hybrid_recruiter AS is_hybrid_recruiter_311, b14_.address AS address_312, b14_.created_at AS created_at_313, b14_.updated_at AS updated_at_314, b0_.employer_id AS employer_id_315, b0_.staffing_agency_id AS staffing_agency_id_316, b0_.recruiter_id AS recruiter_id_317, b0_.provider_id AS provider_id_318, b0_.job_id AS job_id_319, b0_.interview_id AS interview_id_320, b1_.user_id AS user_id_321, b1_.employer_id AS employer_id_322, b1_.staffing_agency_id AS staffing_agency_id_323, b1_.profession_id AS profession_id_324, b1_.speciality_id AS speciality_id_325, b1_.assigned_recruiter_id AS assigned_recruiter_id_326, b2_.user_id AS user_id_327, b4_.user_id AS user_id_328, b6_.user_id AS user_id_329, b7_.user_id AS user_id_330, b8_.user_id AS user_id_331, b8_.profession_id AS profession_id_332, b9_.dtype AS dtype_333, b9_.employer_id AS employer_id_334, b9_.staffing_agency_id AS staffing_agency_id_335, b9_.membership_tier_id AS membership_tier_id_336, b9_.recruiter_id AS recruiter_id_337, b10_.dtype AS dtype_338, b10_.employer_id AS employer_id_339, b10_.staffing_agency_id AS staffing_agency_id_340, b10_.membership_tier_id AS membership_tier_id_341, b10_.recruiter_id AS recruiter_id_342, b11_.user_id AS user_id_343, b13_.user_id AS user_id_344, b14_.dtype AS dtype_345, b14_.employer_id AS employer_id_346, b14_.staffing_agency_id AS staffing_agency_id_347, b14_.membership_tier_id AS membership_tier_id_348, b14_.recruiter_id AS recruiter_id_349 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id LEFT JOIN b_employer b2_ ON b0_.employer_id = b2_.id LEFT JOIN b_staffing_agency b3_ ON b0_.staffing_agency_id = b3_.id LEFT JOIN b_employer b4_ ON b1_.employer_id = b4_.id LEFT JOIN b_staffing_agency b5_ ON b1_.staffing_agency_id = b5_.id LEFT JOIN b_recruiter b6_ ON b0_.recruiter_id = b6_.id LEFT JOIN b_recruiter b7_ ON b1_.assigned_recruiter_id = b7_.id LEFT JOIN b_job_recruiter b15_ ON b1_.id = b15_.job_id LEFT JOIN b_provider b8_ ON b0_.provider_id = b8_.id LEFT JOIN b_user b9_ ON b8_.user_id = b9_.id AND b9_.dtype IN ('user') LEFT JOIN b_user b10_ ON b1_.user_id = b10_.id AND b10_.dtype IN ('user') LEFT JOIN b_employer b11_ ON b10_.employer_id = b11_.id LEFT JOIN b_staffing_agency b12_ ON b10_.staffing_agency_id = b12_.id LEFT JOIN b_recruiter b13_ ON b10_.id = b13_.user_id LEFT JOIN b_user b14_ ON b7_.user_id = b14_.id AND b14_.dtype IN ('user') WHERE 1 = 1 AND b0_.archived_at IS NULL AND b0_.status IN (?) AND b0_.employer_id = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.id DESC"
  "params" => [
    1 => "applied"
    2 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
    3 => b"\x1F\x13³ÔÉÑa\x1Cˆõ_SÂËâ|"
    4 => b"\x1F\x13’DzEmx²2GÁjð;ô"
    5 => b"\x1F\x13zÆÇn8ž›+ûH1F\x1E"
    6 => b"\x1F\x13;bx\x1Cc蚈M.§v¿E"
    7 => b"\x1F\x12░¦‗\x0Eb£é¿eeÉ#Oß"
    8 => b"\x1F\x12`\x08¥œ`â›\x04\x07¤¿ø.f"
    9 => b"\x1F\x12ZIûµhFöëôØ┌Å1ü"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 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.user_id = ?"
  "params" => [
    1 => b"""
      \x1F\x11=\x1E\x1Eýmx•¤µ\n
      Ã!ƒ¸
      """
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.balance AS balance_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM b_credit_wallet t0 WHERE t0.user_id = ?"
  "params" => [
    1 => b"""
      \x1F\x11=\x1E\x1Eýmx•¤µ\n
      Ã!ƒ¸
      """
  ]
  "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.user_id = ?"
  "params" => [
    1 => b"\x1F\x12\x14À‘ƒc¾„ž/ò×/Uš"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.balance AS balance_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM b_credit_wallet t0 WHERE t0.user_id = ?"
  "params" => [
    1 => b"\x1F\x12\x14À‘ƒc¾„ž/ò×/Uš"
  ]
  "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.employer_id = ? AND t0.provider_id = ? AND t0.job_id = ? AND t0.is_completed = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
    2 => b"\x1F\x11ßL€)kl‚“¿À\x1FѾU"
    3 => b"\x1F\x13│Ðð\x02`\fÅ>Ú¡\fÞ╝ã"
    4 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
  ]
]

[
  "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.employer_id = ? AND t0.provider_id = ? AND t0.job_id = ? AND t0.is_completed = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
    2 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
    3 => b"\x1F\x13’½üïf¨”Ês)…šK¡"
    4 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
  ]
]

[
  "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.employer_id = ? AND t0.provider_id = ? AND t0.job_id = ? AND t0.is_completed = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
    2 => b"\x1F\x11ßL€)kl‚“¿À\x1FѾU"
    3 => b"\x1F\x13z¸K<nd™m\x037ék™\x11"
    4 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
  ]
]

[
  "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.employer_id = ? AND t0.provider_id = ? AND t0.job_id = ? AND t0.is_completed = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
    2 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
    3 => b"\x1F\x13;U™§ad¦ÞýZ˜õ1\t"
    4 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
  ]
]

[
  "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.employer_id = ? AND t0.provider_id = ? AND t0.job_id = ? AND t0.is_completed = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
    2 => b"\x1F\x11ßL€)kl‚“¿À\x1FѾU"
    3 => b"\x1F\x12°Ð,é`\x14…ïgÐÈÙl'"
    4 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
  ]
]

[
  "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.employer_id = ? AND t0.provider_id = ? AND t0.job_id = ? AND t0.is_completed = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
    2 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
    3 => b"\x1F\x12_¹Ø1cjÅ╝}¾¥âÓ‗"
    4 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
  ]
]

[
  "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.employer_id = ? AND t0.provider_id = ? AND t0.job_id = ? AND t0.is_completed = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
    2 => b"\x1F\x12\x14À‹@mž€Û/ò×/Uš"
    3 => b"\x1F\x12L\x070fbØ“\x00\x03’K°4È"
    4 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
  ]
]

[
  "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\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
  ]
  "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\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
    2 => "EMPLOYER"
    3 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.balance AS balance_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM b_credit_wallet t0 WHERE t0.user_id = ? LIMIT 1"
  "params" => [
    1 => b"\x1F\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.balance AS balance_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM b_credit_wallet t0 WHERE t0.user_id = ? LIMIT 1"
  "params" => [
    1 => b"\x1F\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
  ]
  "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.staffing_agency_id AS staffing_agency_id_14, t0.application_id AS application_id_15 FROM b_review t0 WHERE t0.application_id = ?"
  "params" => [
    1 => b"\x1F\x13³ÔÉÑa\x1Cˆõ_SÂËâ|"
  ]
  "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.staffing_agency_id AS staffing_agency_id_14, t0.application_id AS application_id_15 FROM b_review t0 WHERE t0.application_id = ?"
  "params" => [
    1 => b"\x1F\x13’DzEmx²2GÁjð;ô"
  ]
  "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.staffing_agency_id AS staffing_agency_id_14, t0.application_id AS application_id_15 FROM b_review t0 WHERE t0.application_id = ?"
  "params" => [
    1 => b"\x1F\x13zÆÇn8ž›+ûH1F\x1E"
  ]
  "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.staffing_agency_id AS staffing_agency_id_14, t0.application_id AS application_id_15 FROM b_review t0 WHERE t0.application_id = ?"
  "params" => [
    1 => b"\x1F\x13;bx\x1Cc蚈M.§v¿E"
  ]
  "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.staffing_agency_id AS staffing_agency_id_14, t0.application_id AS application_id_15 FROM b_review t0 WHERE t0.application_id = ?"
  "params" => [
    1 => b"\x1F\x12░¦‗\x0Eb£é¿eeÉ#Oß"
  ]
  "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.staffing_agency_id AS staffing_agency_id_14, t0.application_id AS application_id_15 FROM b_review t0 WHERE t0.application_id = ?"
  "params" => [
    1 => b"\x1F\x12`\x08¥œ`â›\x04\x07¤¿ø.f"
  ]
  "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.staffing_agency_id AS staffing_agency_id_14, t0.application_id AS application_id_15 FROM b_review t0 WHERE t0.application_id = ?"
  "params" => [
    1 => b"\x1F\x12ZIûµhFöëôØ┌Å1ü"
  ]
  "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"
]